Difference between revisions of "User Management"
From dbawiki
(→Users created when installing Oracle 11.2.0.4 Enterprise Edition) |
(→On Windows...) |
||
| Line 96: | Line 96: | ||
grant create session to "ops$domainname.com\oracle"; | grant create session to "ops$domainname.com\oracle"; | ||
</pre> | </pre> | ||
| − | Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora" | + | Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora"<br /> |
| + | If this is not present, you will not be able to connect as sysdba | ||
<pre> | <pre> | ||
| − | SQLNET.AUTHENTICATION_SERVICES= (NTS) | + | SQLNET.AUTHENTICATION_SERVICES=(NTS) |
</pre> | </pre> | ||
Revision as of 15:14, 13 April 2016
Contents
Users created when installing Oracle 11.2.0.4 Standard Edition
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.
Users created when installing Oracle 11.2.0.4 Enterprise Edition
select username from dba_users order by 1; USERNAME ------------------------------ ANONYMOUS APEX_030200 APEX_PUBLIC_USER APPQOSSYS CTXSYS DBSNMP DIP EXFSYS FLOWS_FILES MDDATA MDSYS MGMT_VIEW OLAPSYS ORACLE_OCM ORDDATA ORDPLUGINS ORDSYS OUTLN OWBSYS OWBSYS_AUDIT SI_INFORMTN_SCHEMA SPATIAL_CSW_ADMIN_USR SPATIAL_WFS_ADMIN_USR SYS SYSMAN SYSTEM WMSYS XDB XS$NULL 29 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"
If this is not present, you will not be able to connect as sysdba
SQLNET.AUTHENTICATION_SERVICES=(NTS)
