Oracle Grant Summary

1.select * from Dba_users; --Querying all users in the database

2.GRANT SELECT on TableName to username;--authorization query (delegate the query rights of the table TableName to UserName)
Grant insert on TableName to username;--authorization insertion (delegate the right to insert the table TableName to UserName)
Grant update on TableName to username;--authorized updates (Grant UserName the update rights to the table TableName)

Grant UPDATE on Table1 to userName with GRANT option; --Authorization Update permission to transfer to the user, the user can continue to authorize;

Grant EXECUTE on Procedure1 to username;--authorization stored procedure

3.revoke Select on table1 from User1; --The right to retrieve the query table;

Revoke all in Table1 from user1;--to retract all permissions for table table1;

4.select Table_name,privilege from Dba_tab_privs where grantee= ' Xujin ';--querying permissions for objects owned by a user

SELECT * from Dba_sys_privs where grantee= ' Xujin ';--query for system permissions owned by a user

SELECT * from Session_privs;--a system permissions that are valid for the current session

Oracle Grant Summary