Security manager, only show one database.

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
kaffeburk
Posts: 211
Joined: Mon 29 Jan 2007 08:03

Security manager, only show one database.

Post by kaffeburk » Wed 18 Apr 2018 11:40

Hello,

I want a user to have all privileges for one database only. The other databases should not be shown. I'm able to limit so he can not alter them, but i don't want him to see them. How can i make this?

alexa
Devart Team
Posts: 2830
Joined: Fri 24 Jun 2011 14:17

Re: Security manager, only show one database.

Post by alexa » Wed 18 Apr 2018 13:27

Please see the following sample user with the full access to the sakila database:

Code: Select all

CREATE USER 'testuser'@'%' IDENTIFIED WITH mysql_native_password PASSWORD EXPIRE DEFAULT;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, GRANT OPTION, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, EVENT, TRIGGER ON sakila.* TO 'testuser'@'%';

SET PASSWORD FOR 'testuser'@'%' = PASSWORD ('11111');
Here is how it will look like:
Image

Post Reply