使用操作系统认证登陆oracle

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 = /

 

阅读更多
个人分类: oracle
上一篇如何查询出完全是数字的某个字符串
下一篇ftp命令
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭