Question:What are the purposes of GRANT and REVOKE commands?
Answer The GRANT and REVOKE commands are used to manage access privileges. GRANT command needs to assign new privileges to a user or group of users whereas the REVOKE command is responsible for deleting previously granted privileges from user or group of users. example: mysql> GRANT select,insert ON library.book TO jone@localhost IDENTIFIED BY 'open123'; mysql> REVOKE insert ON library.book TO jone@localhost;
Deprecated: html_entity_decode(): Passing null to parameter #1 ($string) of type string is deprecated in D:\webserver\www\vcampusbd_com_https\answers\column_answer_two.php on line 128
+ Report
Total Preview: 976
What are the purposes of GRANT and REVOKE commands?