How to grant a user permission to select only from any host but to a specific table of a database
- برمجة سي كيو ال sql
- 2021-09-02
- mhanasmh00489829403
الأجوبة
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"];Example :
grant select on posts.url_master to jhon@'%' identified by 'mypassword';
flush privileges;أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال