eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Itpub Oracle10g培训 | Blog首页 | 人像摄影~ »

使用Oracle外部身份认证,提高系统安全性

Oracle允许通过外部身份认证创建用户,这样登陆时可以不需要输入口令,从而提高安全性。
以下是Linux中测试的例子.
[oracle@jumper oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Mar 21 09:44:03 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

show 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> show parameters os_authent_prefix 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix                    string      ops$
SQL> create user ops$gqgai identified externally;

User created.

SQL> grant connect to ops$gqgai;

Grant succeeded.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
[oracle@jumper oracle]$ su - gqgai
Password: 
[gqgai@jumper gqgai]$ sqlplus /

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Mar 21 10:08:00 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> show user
USER is "OPS$GQGAI"
SQL> 



简单测试,仅供参考。

~
历史上的今天...
    >> 2011-03-21文章:
    >> 2010-03-21文章:
    >> 2009-03-21文章:
    >> 2008-03-21文章:
    >> 2006-03-21文章:
           看图组字
           完成网站迁移

无觅

By eygle on 2005-03-21 10:18 | Comments (0) | FAQ | 214 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com