SESSION_PRIVS权限是用来获取用户当前的系统权限。

sys@ORCL> SELECT * FROM SESSION_PRIVS;

PRIVILEGE
----------------------------------------
ALTER SYSTEM
AUDIT SYSTEM
CREATE SESSION
ALTER SESSION
RESTRICTED SESSION
CREATE TABLESPACE
ALTER TABLESPACE
MANAGE TABLESPACE
DROP TABLESPACE
UNLIMITED TABLESPACE
CREATE USER
BECOME USER
ALTER USER

参考：

SESSION_PRIVS http://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5148.htm

SESSION_PRIVS和SESSION_ROLES动态视图http://space.itpub.net/4227/viewspace-674527