Create user with access to Mysql Database views only

Asked

Viewed 674 times

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

mysql

1 answer

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!!! !

  • 2

    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.