GRANT statement : Grant « User Permission « SQL / MySQL

1. SQL / MySQL
2. User Permission
3. Grant

GRANT statement

     

CREATE TABLE Books
(
    BookID SMALLINT NOT NULL PRIMARY KEY,
    BookTitle VARCHAR(60) NOT NULL,
    Copyright YEAR NOT NULL
)
ENGINE=INNODB;


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

drop table Books;

   
    
    
    
    
  

Related examples in the same category