René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
System privileges [Oracle] | ||
administer 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 session
Needed to create a session. Oracle throws a ORA-01045 if this privilege is missing when someone tries to connect
to a database (unless the user is a proxy user)
create 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 transaction
Needed for transaction queries and ....? not yet finished
sysdba
See this link.
sysoperunder any tableunder any typeunder any viewunlimited tablespaceupdate any table |