Difference between revisions of "User Management"
From dbawiki
(→Create external user) |
|||
| Line 1: | Line 1: | ||
* [https://oracle-base.com/articles/misc/os-authentication Create external user (using OPS$)] | * [https://oracle-base.com/articles/misc/os-authentication Create external user (using OPS$)] | ||
* [[Create User like...]] | * [[Create User like...]] | ||
| + | ===Users created when installing Oracle 11.2.0.4 Standard Edition=== | ||
| + | <pre> | ||
| + | SYS@ATHARCHT> select username from dba_users order by 1; | ||
| + | |||
| + | USERNAME | ||
| + | ------------------------------ | ||
| + | ANONYMOUS | ||
| + | APEX_030200 | ||
| + | APEX_PUBLIC_USER | ||
| + | APPQOSSYS | ||
| + | CTXSYS | ||
| + | DBSNMP | ||
| + | DIP | ||
| + | EXFSYS | ||
| + | FLOWS_FILES | ||
| + | MDSYS | ||
| + | MGMT_VIEW | ||
| + | ORACLE_OCM | ||
| + | ORDDATA | ||
| + | ORDPLUGINS | ||
| + | ORDSYS | ||
| + | OUTLN | ||
| + | OWBSYS | ||
| + | OWBSYS_AUDIT | ||
| + | SI_INFORMTN_SCHEMA | ||
| + | SYS | ||
| + | SYSMAN | ||
| + | SYSTEM | ||
| + | WMSYS | ||
| + | XDB | ||
| + | XS$NULL | ||
| + | |||
| + | 25 rows selected. | ||
| + | </pre> | ||
===Create external user=== | ===Create external user=== | ||
====Check the authentification prefix==== | ====Check the authentification prefix==== | ||
Revision as of 11:29, 22 January 2016
Contents
Users created when installing Oracle 11.2.0.4 Standard Edition
SYS@ATHARCHT> select username from dba_users order by 1; USERNAME ------------------------------ ANONYMOUS APEX_030200 APEX_PUBLIC_USER APPQOSSYS CTXSYS DBSNMP DIP EXFSYS FLOWS_FILES MDSYS MGMT_VIEW ORACLE_OCM ORDDATA ORDPLUGINS ORDSYS OUTLN OWBSYS OWBSYS_AUDIT SI_INFORMTN_SCHEMA SYS SYSMAN SYSTEM WMSYS XDB XS$NULL 25 rows selected.
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)
