OBJECT PRIVILEGES:
This type of privileges is granted by the owner of the particular object to another user of the database.The privileges are listed here and it is granted according to the object which depends on owner of the object.
The privileges are as follows:SELECT,INSERT,UPDATE,DELETE,ALTER,DEBUG,FLASHBACK,ON COMMIT REFRESH,QUERY REWRITE,REFERENCES,EXECUTE,ALL
I have a table named "my_table" and I wanted to grant it to user "blend".He requires to perform select,insert and delete operation on "my_table" object.I will grant him like this :
Code:
SQL> GRANT SELECT,INSERT,DELETE ON MY_TABLE TO BLEND;
Bookmarks