First1Last
1 of 1 pages
  1. 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;

    Explanation: Not available 


    1. Forum
First1Last
1 of 1 pages