Difference between revisions of "User Management"
From dbawiki
(Created page with "* Create User like...") |
|||
| Line 1: | Line 1: | ||
| + | * [https://oracle-base.com/articles/misc/os-authentication Create external user (using OPS$)] | ||
* [[Create User like...]] | * [[Create User like...]] | ||
| + | ===Create external user=== | ||
| + | ====Check the authentification prefix==== | ||
| + | <pre> | ||
| + | SQL> show parameter authent | ||
| + | |||
| + | NAME TYPE VALUE | ||
| + | ------------------------------------ ----------- ------------------------------ | ||
| + | os_authent_prefix string ops$ | ||
| + | SQL> | ||
| + | </pre> | ||
| + | <pre> | ||
| + | ====On Unix...==== | ||
| + | create user ops$oracle identified externally; | ||
| + | grant create session to ops$oracle; | ||
| + | </pre> | ||
| + | ====On Windows...==== | ||
| + | Watch out on Windows - the domain name needs to be included! | ||
| + | <pre> | ||
| + | create user "ops$domainname.com\oracle" identified externally; | ||
| + | grant create session to "ops$domainname.com\oracle"; | ||
| + | </pre> | ||
| + | Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora" | ||
| + | <pre> | ||
| + | SQLNET.AUTHENTICATION_SERVICES= (NTS) | ||
| + | </pre> | ||
Revision as of 12:42, 8 November 2015
Create external user
Check the authentification prefix
SQL> show parameter authent NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ os_authent_prefix string ops$ SQL>
====On Unix...==== create user ops$oracle identified externally; grant create session to ops$oracle;
On Windows...
Watch out on Windows - the domain name needs to be included!
create user "ops$domainname.com\oracle" identified externally; grant create session to "ops$domainname.com\oracle";
Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora"
SQLNET.AUTHENTICATION_SERVICES= (NTS)
