Common Oracle authorization and permission revocation in January 9, 2014

1. A set of common system permissions granted by GRANT has the following three permissions:

CONNECT (basic connection), RESOURCE (Program Development), DBA (Database Management)

Common Data Objects have the following permissions: all on Data Object Name, select on Data Object Name, update on Data Object Name,

Delete on Data Object Name, insert on Data Object Name, alter on Data Object Name

 

Grant connect, resource to user name;

Grant select on table name TO user name;

Grant select, INSERT, delete on table name TO username 1, username 2;

2. REVOKE permissions from REVOKE

Revoke connect, resource from username;

Revoke select on table name FROM user name;

Revoke select, INSERT, delete on table name FROM username 1, username 2;