oracle判斷目前使用者是不是dba

SELECT * FROM session_privs
這個在sqlplus裡可以查看目前使用者所有許可權，

查看是否是dba
select userenv('isdba') from dual;

查看當前schema和user:

select sys_context('userenv','current_user')
as current_user
from dual;

select sys_context('userenv','current_schema')
as current_schema
from dual;

------------------------------------------
oracle版本：

Oracle9i Enterprise Edition Release 9.2.0.1.0-
Production With the Partitioning,OLAP and Oracle Data Mining Options
JServer Release 9.2.0.1.0