2017-03-24 00:00:00小静 Oracle认证
The default value of this parameter is OPS$ for backward compatibility with previous versions. However, you might prefer to set the prefix value to "" (a null string), thereby eliminating the addition of any prefix to operating system account names.
可见,用ops$只是为了向前兼容。
下面,我们来实验一下。
一、创建操作系统用户
[root@node1 ~]# useradd test
二、创建Oracle用户并授予相应的权限
SQL> create user ops$test identified externally;
SQL> grant create session to ops$test;
三、用test用户登录数据库
[test@node1 ~]$ /u01/app/oracle/product/11.2.0.4/db_1/bin/sqlplus /
Error 6 initializing SQL*Plus
SP2-0667: Mess ..........
阅读全文[Oracle认证]热门推荐
861
人