GRANT {objpriv | ALL [privs]} [(column,column)]
ON object TO {user | role}
[WITH GRANT OPTION][WITH HIERARCHY OPTION];i.e.,GRANT select ON emp TO lynn;
REVOKE ALL ON emp FROM lynn;
| Table | View | Materialized View | Sequence | Procedure, Function, Package, Operator, Index type, Library | Directory (for BFile or External) | Abstract data type |
| All | -- | -- | -- | -- | -- | -- |
| Alter (table --all or specific columns) | -- | -- | Alter | -- | -- | -- |
| Delete | Delete | Delete (if updateable) | -- | -- | -- | -- |
| -- | -- | -- | -- | Execute | -- | Execute |
| Debug | -- | -- | -- | Debug | -- | Debug |
| Flashback | Flashback | Flashback | -- | -- | -- | -- |
| Index (columns in a table) | -- | -- | -- | -- | -- | -- |
| Insert | Insert | Insert (if updateable) | -- | -- | -- | -- |
| On Commit Refresh | -- | -- | -- | -- | -- | -- |
| Query Rewrite | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | Read | -- |
| References | -- | -- | -- | -- | -- | -- |
| Select | Select | Select | Select | -- | -- | -- |
| -- | Under | -- | -- | -- | -- | Under |
| Update (all or specific columns) | Update (all or specific columns) | Update (all or specific columns) (if updateable) | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | Write | -- |
Posts
No comments:
Post a Comment