Según el objeto de que se trate, en Oracle podemos dar los siguientes privilegios:
Tables: select, insert, update, delete, alter, debug, flashback, on commit refresh, query rewrite, references, all
Views: select, insert, update, delete, under, references, flashback, debug
Sequence: alter, select
Packages, Procedures, Functions (Java classes, sources…): execute, debug
Materialized Views: delete, flashback, insert, select, update
Directories: read, write
Libraries: execute
User defined types: execute, debug, under
Operators: execute
Indextypes: execute