Difference between revisions of "User Management"
From dbawiki
| Line 11: | Line 11: | ||
SQL> | SQL> | ||
</pre> | </pre> | ||
| + | ====On Unix...==== | ||
<pre> | <pre> | ||
| − | |||
create user ops$oracle identified externally; | create user ops$oracle identified externally; | ||
grant create session to ops$oracle; | grant create session to ops$oracle; | ||
Revision as of 12:42, 8 November 2015
Contents
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)
