Grant with user name and password : SQL Privilege : User Permission SQL / MySQL

SQL / MySQL » User Permission » SQL Privilege »

Grant with user name and password



  
GRANT SELECT, UPDATE (columnName1, columnName2)
ON databaseName.tableName
TO 'userName'@'domain1.com' IDENTIFIED BY 'password'
REQUIRE SUBJECT 'test client cert.'
  AND ISSUER 'Test C.A.';

Related Scripts with Example Source Code in same category :

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

SQL / MySQL » User Permission » SQL Privilege »

Grant with user name and password

Leave a Comment / Note

SQL / MySQL