采用操作外部系统认证(unix or linux 等 OS)
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 = /
windows下稍微有点差异,请去 www.itpub.net 搜索