pardip sidhu

 Profile Answers by pardip sidhu 

• Oct 25th, 2005

 

Basically,This is a part of D.B.A responsibilities GRANT means permissions for example GRANT CREATE TABLE ,CREATE VIEW AND MANY MORE .

                  REVOKE means cancel the grant (permissions).So,Grant or Revoke both commands depend upon D.B.A.

prakirn

 Profile Answers by prakirn 

• Mar 1st, 2008

 

GRANT command is used to give permission to users to do or create a specific object in the database.
On the other side, REVOKE is used to pull back the permission.

Internally these 2 commands make entries into data dictionary tables.