Grant select, update privilege for a remote user : Grant : Privilege MySQL TUTORIALS

MySQL TUTORIALS » Privilege » Grant »

Grant select, update privilege for a remote user


GRANT SELECT, UPDATE (Title, start_date)
ON test.Employee
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1'
REQUIRE SUBJECT 'test client cert.'
  AND ISSUER 'Test C.A.';

Related Scripts with Example Source Code in same category :

Granting Privileges on the new database
A user doesn't need a password if connecting from a certain machine
WITH GRANT OPTION condition allows the user to give others privileges to that database
GRANT ALL
Add localhost to mysql table for accessing sample_db
Grant Select and Update privilege to a user
GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
GRANT SELECT, UPDATE ON databaseName.*

MySQL TUTORIALS

Privilege
» Grant

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

Grant select, update privilege for a remote user : Grant : Privilege MySQL TUTORIALS

MySQL TUTORIALS » Privilege » Grant »

Grant select, update privilege for a remote user

Leave a Comment / Note

MySQL TUTORIALS