Database user based on external OS verification

zhaozj2021-02-12  131

Working external system certification (Unix or Linux, etc. OS) SQL> show parameters OS_AUTHENT_PREFIX NAME TYPE VALUE -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------- OS_AUTHENT_PREFIX STRING OPS $ SQL> CREATE User " OPS $ ORACLE "PROFILE" DEFAULT "IDENTIFIED EXTERNALLY DEFAULT TABLESPACE" USERS "TEMPORARY TABLESPACE" TEMP "; User created SQL> grant connect to ops $ oracle;... Grant succeeded SQL> conn / Connected SQL> SQL> show user USER is "OPS $ ORACLE" SQL> SQL> exit Disconnected from Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta With the Partitioning, OLAP and Oracle Data Mining options [oracle @ linux oracle] $ sqlplus / SQL * Plus: Release 10.1.0.0 .0 - Beta on Tue Aug 19 16:04:46 2003 Copyright (C) 1982, 2003, Oracle Corporation. Connected to: Oracle10i Enterprise Edition Release 10.1.0.0.0 - Beta with the partitioning, OLAP AND ORACLE Data Mining Options SQL> SHOW User User IS "OPS $ Oracle" SQL> When you create a user, the name is OS_AUTHENT_PREFIX OS NAME, as long as the OS NAME logs in the database, as long as it is usable / Userid = USER / Pass now UserId = /

Windows is a bit different from WINDOWS, please go www.itpub.net search

转载请注明原文地址:https://www.9cbs.com/read-7566.html

New Post(0)