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

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2005/03/eoaoracleiaeiei.html

站内相关文章|Related Articles

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>

简单测试，仅供参考。

~
历史上的今天...
>> 2009-03-21文章:

db_file_multiblock_read_count 的自动调整

>> 2008-03-21文章:

注意安全-北京地铁目击当众抢劫

>> 2006-03-21文章:

看图组字

完成网站迁移

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

相关文章	随机文章
	明天赴杭参加"中国网络工程师侠客行"大会恭王府赏福字碑月光-王心凌 HDS Truecopy实现原理及项目的选择 Oracle Metalink帐号重要更改策略

搜索本站:

www.eygle.com

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

留言 (0)

发表留言: