For the one table permission to view data, follow the below process:
1) Create the MySQL User
CREATE USER 'USERNAME'@'USER_IP/HOST_NAME';
2) Execute the permission query to view only single table/view data
GRANT SELECT ON database.table / view to 'username'@'USER_IP/HOST_NAME' identified by 'password';
1) Create the MySQL User
CREATE USER 'USERNAME'@'USER_IP/HOST_NAME';
2) Execute the permission query to view only single table/view data
GRANT SELECT ON database.table / view to 'username'@'USER_IP/HOST_NAME' identified by 'password';
No comments:
Post a Comment