1. 首页
  2. IT资讯

system_privilege_map & table_privilege_map

oracle把权限和用户完全分开,权限的集合=role,然后采用授权的方式给用户

[@more@]

1、select * from user_tab_privs where grantor=’TEST’;建立在table级别上的有11个对象权限,其中on commit refresh ,query rewrite is for mview(materialized view)

PRIVILEGEALTERDEBUGDELETEFLASHBACKINDEXINSERTON COMMIT REFRESHQUERY REWRITEREFERENCESSELECTUPDATE

2、select * from table_privilege_map反应的是所有pl/sql schema object的权限

存在24条记录,包括全部的对象权限

NAMEALTERAUDITCOMMENTCREATEDEBUGDELETEDEQUEUEENQUEUEEXECUTEFLASHBACKGRANTINDEXINSERTLOCKMERGE VIEWON COMMIT REFRESHQUERY REWRITEREADREFERENCESRENAMESELECTUNDERUPDATEWRITE

3、Select Name From system_privilege_map系统权限 166个

NAMEADMINISTER ANY SQL TUNING SETADMINISTER DATABASE TRIGGERADMINISTER RESOURCE MANAGERADMINISTER SQL TUNING SETADVISORALTER ANY CLUSTERALTER ANY DIMENSIONALTER ANY EVALUATION CONTEXTALTER ANY INDEXALTER ANY INDEXTYPEALTER ANY LIBRARYALTER ANY MATERIALIZED VIEWALTER ANY OPERATORALTER ANY OUTLINEALTER ANY PROCEDUREALTER ANY ROLEALTER ANY RULEALTER ANY RULE SETALTER ANY SEQUENCEALTER ANY SQL PROFILEALTER ANY TABLEALTER ANY TRIGGERALTER ANY TYPEALTER DATABASEALTER PROFILEALTER RESOURCE COSTALTER ROLLBACK SEGMENTALTER SESSIONALTER SYSTEMALTER TABLESPACEALTER USERANALYZE ANYANALYZE ANY DICTIONARYAUDIT ANYAUDIT SYSTEMBACKUP ANY TABLEBECOME USERCHANGE NOTIFICATIONCOMMENT ANY TABLECREATE ANY CLUSTERCREATE ANY CONTEXTCREATE ANY DIMENSIONCREATE ANY DIRECTORYCREATE ANY EVALUATION CONTEXTCREATE ANY INDEXCREATE ANY INDEXTYPECREATE ANY JOBCREATE ANY LIBRARYCREATE ANY MATERIALIZED VIEWCREATE ANY OPERATORCREATE ANY OUTLINECREATE ANY PROCEDURECREATE ANY RULECREATE ANY RULE SETCREATE ANY SEQUENCECREATE ANY SQL PROFILECREATE ANY SYNONYMCREATE ANY TABLECREATE ANY TRIGGERCREATE ANY TYPECREATE ANY VIEWCREATE CLUSTERCREATE DATABASE LINKCREATE DIMENSIONCREATE EVALUATION CONTEXTCREATE EXTERNAL JOBCREATE INDEXTYPECREATE JOBCREATE LIBRARYCREATE MATERIALIZED VIEWCREATE OPERATORCREATE PROCEDURECREATE PROFILECREATE PUBLIC DATABASE LINKCREATE PUBLIC SYNONYMCREATE ROLECREATE ROLLBACK SEGMENTCREATE RULECREATE RULE SETCREATE SEQUENCECREATE SESSIONCREATE SYNONYMCREATE TABLECREATE TABLESPACECREATE TRIGGERCREATE TYPECREATE USERCREATE VIEWDEBUG ANY PROCEDUREDEBUG CONNECT SESSIONDELETE ANY TABLEDEQUEUE ANY QUEUEDROP ANY CLUSTERDROP ANY CONTEXTDROP ANY DIMENSIONDROP ANY DIRECTORYDROP ANY EVALUATION CONTEXTDROP ANY INDEXDROP ANY INDEXTYPEDROP ANY LIBRARYDROP ANY MATERIALIZED VIEWDROP ANY OPERATORDROP ANY OUTLINEDROP ANY PROCEDUREDROP ANY ROLEDROP ANY RULEDROP ANY RULE SETDROP ANY SEQUENCEDROP ANY SQL PROFILEDROP ANY SYNONYMDROP ANY TABLEDROP ANY TRIGGERDROP ANY TYPEDROP ANY VIEWDROP PROFILEDROP PUBLIC DATABASE LINKDROP PUBLIC SYNONYMDROP ROLLBACK SEGMENTDROP TABLESPACEDROP USERENQUEUE ANY QUEUEEXECUTE ANY CLASSEXECUTE ANY EVALUATION CONTEXTEXECUTE ANY INDEXTYPEEXECUTE ANY LIBRARYEXECUTE ANY OPERATOREXECUTE ANY PROCEDUREEXECUTE ANY PROGRAMEXECUTE ANY RULEEXECUTE ANY RULE SETEXECUTE ANY TYPEEXEMPT ACCESS POLICYEXEMPT IDENTITY POLICYEXPORT FULL DATABASEFLASHBACK ANY TABLEFORCE ANY TRANSACTIONFORCE TRANSACTIONGLOBAL QUERY REWRITEGRANT ANY OBJECT PRIVILEGEGRANT ANY PRIVILEGEGRANT ANY ROLEIMPORT FULL DATABASEINSERT ANY TABLELOCK ANY TABLEMANAGE ANY FILE GROUPMANAGE ANY QUEUEMANAGE FILE GROUPMANAGE SCHEDULERMANAGE TABLESPACEMERGE ANY VIEWON COMMIT REFRESHQUERY REWRITEREAD ANY FILE GROUPRESTRICTED SESSIONRESUMABLESELECT ANY DICTIONARYSELECT ANY SEQUENCESELECT ANY TABLESELECT ANY TRANSACTIONSYSDBASYSOPERUNDER ANY TABLEUNDER ANY TYPEUNDER ANY VIEWUNLIMITED TABLESPACEUPDATE ANY TABLE

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027075/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194750.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code