grant connect,resource to user;后用户包括的权限
CONNECT角色:–是授予最终用户的典型权利,最基本的ALTERSESSION–修改会话CREATECLUSTER–建立聚簇CREATEDATABASELINK–建立数据库链接CREATESEQUENCE–建立序列CREATESESSION–建立会话CREATESYNONYM–建立同义词CREATEVIEW–建立视图RESOURCE角色:–是授予开发人员的CREATECLUSTER–建立聚簇CREATEPROCEDURE–建立过程CREATESEQUENCE–建立序列CREATETABLE–建表CREATETRIGGER–建立触发器CREATETYPE–建立类型从dba_sys_privs里可以查到
SQL> select grantee,privilege from dba_sys_privs2where grantee=’RESOURCE’ order by privilege;
GRANTEEPRIVILEGE———— ———————-RESOURCECREATE CLUSTERRESOURCECREATE INDEXTYPERESOURCECREATE OPERATORRESOURCECREATE PROCEDURERESOURCECREATE SEQUENCERESOURCECREATE TABLERESOURCECREATE TRIGGERRESOURCECREATE TYPE
已选择8行。
另外补充:
1、grant update(sname) on student to tech1 with admin option;
这个是给用户tech1以update表student列sname的权限,,并使tech1可以把这个权限授予别人
grant insert(sname,sid) on student to tech1; —多列情况
2、grant alter on test_tab to user1;–给用户user1修改表test_tab的权限
grant alter any table to user1;–给用户user1修改任意表的权限
莫找借口失败,只找理由成功。