Create user with access only to database views in MySQL

Question

Create user with access only to database views in MySQL

Navigation

#1 by (1 votes)

1

How do I create a user that views only the views of my database in MySQL?

I'm using the following settings:

Ubuntu Server 14.04.5 LTS
  MySQL: 5.5.55
  Apache: 2.4.7
  phpMyAdmin: 4.0.10

mysql

asked by anonymous 18.07.2017 / 14:31

1 answer

Emulator without Internet connection How to return pilot names in SQL table?

score 1 · Accepted Answer

Hello,

I believe that if you use the following structure, you will grant the permissions only 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: User Management and Access Control