Grant select and update to all tables : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

Grant select and update to all tables



  
/*  '*' means all tables */
GRANT SELECT, UPDATE
ON test.*
TO 'userName'@'domain1.com' IDENTIFIED BY 'password'
WITH GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50;

Related Scripts with Example Source Code in same category :

Check the privilege
Grant select and update on two column in a table
Grant with user name and password
Grant select and update with time limitation
Check out the privilege for a user
List the host, DB, table name and column name for a user
Adding Users to Database
Read the user table
Read host, db, user, table name and table privilege from privilege table
Read column privilege

SQL / MySQL

User Permission
» SQL Privilege

Backup Load

Command MySQL

Cursor

Data Type

Database

Date Time

Flow Control

Function

Insert Delete Update

Join

Key

Math

String

Trigger

View

Grant select and update to all tables : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

Grant select and update to all tables

Leave a Comment / Note

SQL / MySQL