Grant select and update on two column in a table : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

Grant select and update on two column in a table



  

/* BookTitle and Copyright are field names */

GRANT SELECT, UPDATE (BookTitle, Copyright)
ON databaseName.tableName
TO 'usrName'@'domain1.com' IDENTIFIED BY 'password'
REQUIRE SSL;

Related Scripts with Example Source Code in same category :

Check the privilege
Grant with user name and password
Grant select and update to all tables
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 on two column in a table : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

Grant select and update on two column in a table

Leave a Comment / Note

SQL / MySQL