oracle普通用户创建和加权限
普通用户床架和加权限 create user test1 identified by test1; grant connect to test1;grant resource to test1; grant create snapshot to test1; grant create synonym to test1; grant create view to test1; grant select any table to test1; grant create any trigger to test1; grant create any view to test1; grant select any dictionary to test1; grant unlimited tablespace to test1;
查看角色拥有的权限 select grantee,privilege from dba_sys_privs where grantee='RESOURCE' order by privilege; CONNECT角色: –是授予最终用户的典型权利,最基本的 RESOURCE角色: –是授予开发人员的
1.查看所有用户: 注意: 1、以下语句可以查看Oracle提供的系统权限 select name from sys.system_privilege_map 2、查看一个用户的所有系统权限(包含角色的系统权限) select privilege from dba_sys_privs where grantee='DATAUSER' 参考: http://www.2cto.com/database/201408/322396.html (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |