windows下:
1.建立组:ora_dba
2.建立用户:test,把test加入到组ora_dba
3.SQLNET.ORA参数文件里,必须设置 SQLNET.AUTHENTICATION_SERVICES = (NTS)
登陆时使用connect / as sysdba
unix/linux下:
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. All rights reserved. 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> 创建用户的时候名称为 os_authent_prefix + OS NAME 这样当该 os name 登陆数据库的时候只要使用 / 就可以了 通常 userid = user/pass 现在 userid = /