Grant and Revoke

Grant has the following perceptions:

- CONNECT Can create tables, views, functions, procedures.

- RESOURCE Can create triggers, clusters etc..

- DBA Can create users, grant permissions etc…

- SELECT Can read the table

- INSERT Can insert data into the table

- UPDATE Can modify the data

- DELETE Can delete the data

- ALTER Can alter the data definition

- REFERENCES Can create constraints

- INDEX Can create Indexes.

Ex:

GRANT CONNECT to XXX;

GRANT RESOURCE to XXX;

GRANT DBA to XXX;

GRANT SELECT,INSERT,UPDATE,DELETE to XXX;

GRANT ALTER to XXX;

GRANT REFERENCES to XXX;

GRANT INDEX to XXX;

Ex:

REVOKE CONNECT to XXX;

REVOKE RESOURCE to XXX;

REVOKE DBA to XXX;

REVOKE SELECT,INSERT,UPDATE,DELETE to XXX;

REVOKE ALTER to XXX;

REVOKE REFERENCES to XXX;

REVOKE INDEX to XXX;

Oracle Tweets