« Itpub Oracle10g培训 | Blog首页 | 人像摄影~ »
使用Oracle外部身份认证,提高系统安全性
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2005/03/eoaoracleiaeiei.html
Oracle允许通过外部身份认证创建用户,这样登陆时可以不需要输入口令,从而提高安全性。链接:https://www.eygle.com/archives/2005/03/eoaoracleiaeiei.html
以下是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文章:
历史上的今天...
>> 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 |