Give The Syntax Of Grant Commands?

1.	Give The Syntax Of Grant Commands?
Answer» The generic syntax for GRANT is as following GRANT [RIGHTS] on [database] TO [username@hostname] IDENTIFIED BY [PASSWORD] Now rights can be: a) ALL privilages B) 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. The generic syntax for GRANT is as following GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password] Now rights can be: a) ALL privilages b) 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.

Answer»

The generic syntax for GRANT is as following
GRANT [RIGHTS] on [database] TO [username@hostname] IDENTIFIED BY [PASSWORD]

Now rights can be:
a) ALL privilages
B) 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.

The generic syntax for GRANT is as following
GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]

Now rights can be:
a) ALL privilages
b) 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.

Discussion