oracle查看当前用户权限 oracle查看当前用户权限

问题
分析当前用户有哪些权限。
方法

select * from session_privs;

可以看到当前用户的权限
其中： 1、常见权限

CREATE SESSION CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE DROP ANY TABLE COMMENT ANY TABLE SELECT ANY TABLE INSERT ANY TABLE DELETE ANY TABLE CREATE ANY INDEX ALTER ANY INDEX DROP ANY INDEX CREATE VIEW CREATE ANY VIEW DROP ANY VIEW CREATE SEQUENCE CREATE ANY SEQUENCE ALTER ANY SEQUENCE DROP ANY SEQUENCE SELECT ANY SEQUENCE CREATE DATABASE LINK CREATE PUBLIC DATABASE LINK DROP PUBLIC DATABASE LINK CREATE ANY PROCEDURE ALTER ANY PROCEDURE DROP ANY PROCEDURE EXECUTE ANY PROCEDURE CREATE TRIGGER CREATE ANY TRIGGER ALTER ANY TRIGGER DROP ANY TRIGGER ANALYZE ANY CREATE MATERIALIZED VIEW CREATE ANY MATERIALIZED VIEW ALTER ANY MATERIALIZED VIEW DROP ANY MATERIALIZED VIEW SELECT ANY DICTIONARY DEBUG CONNECT SESSION DEBUG ANY PROCEDURE CREATE JOB CREATE ANY JOB SELECT ANY TRANSACTION

【oracle查看当前用户权限】2、CREATE TABLE与CREATE ANY TABLE区别：
CREATE TABLE只能在当前用户创建表
CREATE ANY TABLE能在任何用户下创建表