oracle外部系统认证用户登录
涉及的相关oracle 参数及其默认值:
REMOTE_OS_AUTHENT=FALSE
OS_AUTHENT_PREFIX=ops$
实践检验:
1、数据库端,新建用户:
create user OPS$JON identified externally;
grant create session to OPS$jon;
2、操作系统端:
useradd jon -g dba -G oinstall
vi .bash_profile
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db1; export ORACLE_HOME
ORACLE_SID=study; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
3、验证登陆情况:
/
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 29 09:06:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show user
USER is "OPS$JON"
总结:
如果OS_AUTHENT_PREFIX="OPS$",
数据库用户名=OPS$+操作系统用户
如果OS_AUTHENT_PREFIX=""
数据库中用户名=操作系统用户名
阅读(3252) | 评论(0) | 转发(0) |