GRANT and REVOKE in MySQL

Controlling Access (DCL)

Examples

-- give SELECT and INSERT on students to user1
GRANT SELECT, INSERT ON school.students TO 'user1'@'localhost';

-- take back INSERT
REVOKE INSERT ON school.students FROM 'user1'@'localhost';

Common Privileges

SELECT, INSERT, UPDATE, DELETE, ALL PRIVILEGES, CREATE, DROP.

Summary

• GRANT gives permissions; REVOKE removes them.
• Used by the DBA to control who can do what.

Access Control (DCL)

Examples

-- user1 को students पर SELECT और INSERT दें
GRANT SELECT, INSERT ON school.students TO 'user1'@'localhost';

-- INSERT वापस लें
REVOKE INSERT ON school.students FROM 'user1'@'localhost';

Common Privileges

SELECT, INSERT, UPDATE, DELETE, ALL PRIVILEGES, CREATE, DROP।

सारांश

• GRANT permissions देता है; REVOKE हटाता है।
• DBA इनसे control करता है कि कौन क्या कर सकता है।