CSDN博客

img tesge

使用操作系统认证登陆oracle

发表于2004/7/6 16:00:00  1331人阅读

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

 

0 0

相关博文

我的热门文章

img
取 消
img