Give The Syntax Of GRANT Commands

  • 27 Dec, 2011

    The generic syntax for GRANT is as followingGRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]Now rights can be:a) ALL privilagesb) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.We can grant rights on all databse by usingh *.* or some specific database by database.* or a specific table by database.table_name.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 All rights reserved.