You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
420 B
SQL
14 lines
420 B
SQL
/*6. How to grant a user permission to select only from any host but to a specific table of a database.
|
|
*/
|
|
/*Syntax :
|
|
|
|
grant [<permission_1,permission_2,...permission_n>|<all>]
|
|
on [database].[<table_name>|<all_tables(*)>]
|
|
to [user name]@[<localhost>|<IP address>|<any host('%')>]
|
|
identified by ["password"];
|
|
*/
|
|
|
|
|
|
grant select on posts.url_master to jhon@'%' identified by 'mypassword';
|
|
flush privileges;
|