July 15th, 2009

Data Control Language, ALL PRIVILEGES

Posted by admin in R. Data Control Language
Format:   GRANT ALL PRIVILEGES
             ON table_name
             TO {user_id | PUBLIC} [WITH GRANT OPTIONS];

ALL PRIVILEGES is used to give all privileges the grantor has to grant to another user.
Generally this is not a good idea, because you may presume that a user has certain rights when they don’t.

Comments are closed.

Sorry, the comment form is closed at this time.