Top "Grant" questions

MySql grant user permission

I want to create a new user in MySql. I do not want that new user to do much with …

mysql grant

User with grant option can't grant create user

I created a user (new_user) with root like this: GRANT ALL ON labor.* TO 'new_user'@'%' WITH …

mysql permissions privileges grant

Grant on multiple databases. MySQL

How to grant on multiple databases? MySQL. Something like GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON 'databasesprefix%'.* TO testuser@…

mysql database grant

Execute Immediate fails even with CREATE table grant

I have a problem where I am creating a table using the execute immediate command in the stored procedure. However …

oracle plsql oracle11g grant execute-immediate

Regenerate GRANTs for roles across schemas

Similar to this question, I would like to know how to generate all GRANT statements issued to all roles in …

sql oracle roles grant

Grant CREATE TABLE permission to MySQL User

I have a database that is shared between some users, and I want to manage their permissions on this. I …

mysql permissions create-table grant

How to grant execute on specific stored procedure to user

I have created some stored procedure on a specific schema. In this stored procedure, I want to grant execute privilege. …

mysql stored-procedures grant

How to create role with MySQL database

Is there a way to use CREATE ROLE with MySQL? It's possible to create roles with PostgreSQL but when I …

mysql roles grant

How to revoke access to *.* for new user in mysql?

In mysql 5.6 command line client (when logged in as root), i created a user with: CREATE USER 'admin'@'localhost' IDENTIFIED …

mysql privileges grant

How do I correctly set ownership and privileges in MariaDB (MySQL)?

I'm trying to setup a database schema on MariaDB which originally comes from PostgreSQL. What is the correct syntax in …

mysql privileges mariadb grant