1
How to create a user that views only views
from my Mysql database?
I am using the following settings:
Ubuntu Server 14.04.5 LTS
Mysql: 5.5.55
Apache: 2.4.7
phpMyAdmin: 4.0.10
1
How to create a user that views only views
from my Mysql database?
I am using the following settings:
Ubuntu Server 14.04.5 LTS
Mysql: 5.5.55
Apache: 2.4.7
phpMyAdmin: 4.0.10
1
Hello,
I believe that if you use the following structure, you grant permissions only to the desired view
GRANT priv [(colunas)] [, priv [(colunas)]] ...
ON {*.* | db.* | db.sua_view}
TO usuario [IDENTIFIED BY 'senha']
[, usuario [IDENTIFIED BY 'senha']] ...
[WITH [GRANT OPTION |
Check out this link: Mysql User Management and Access Control
Marcus, thanks!!! !
For nothing ;). Please mark this as the correct answer.
How to mark this answer as correct? I don’t see option.
Has a button in visa format ("V") below the positive and negative arrows
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
Related: How to make a user in SQL Server 2008 view only a VIEW?
– Homer Simpson