On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Sunday, August 31, 2008

Object Privileges

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 ViewSequence Procedure, Function, Package, Operator,
Index type, Library
Directory (for BFile or External)Abstract data type
All-- -- -- -- -- --
Alter (table --all or specific columns)-- -- Alter-- -- --
DeleteDeleteDelete (if updateable)-- -- -- --
-- -- -- -- Execute-- Execute
Debug-- -- -- Debug-- Debug
FlashbackFlashbackFlashback-- -- -- --
Index (columns in a table)-- -- -- -- -- --
InsertInsertInsert (if updateable)-- -- -- --
On Commit Refresh-- -- -- -- -- --
Query Rewrite-- -- -- -- -- --
-- -- -- -- -- Read--
References-- -- -- -- -- --
SelectSelectSelectSelect-- -- --
-- Under-- -- -- -- Under
Update (all or specific columns)Update (all or specific columns)Update (all or specific columns) (if updateable)-- -- -- --
-- -- -- -- -- Write--

No comments:

Post a Comment