个人博客创业记录-oracle metalink账号|Oracle Metalink账号注册指南

PL/SQL权限
1、查询用户的权限Select * From sys.dba_sys_privsa Where A.grantee= ‘username’;
2、在当前用户下查询当前用户的权限SELECT * FROM session_privs;
3、给用户赋权限Grant select on tablename to username;
4、删除用户的权限Revokecreate table ,select any table ,update any table ,insert any table ,deleteany table ,sysdabFrom user_noracle账号ame;