DCL (Data Control Language)

• 데이터베이스 사용자에게 권한부여하거나 회수함
• 권한(privileges) 종류
  SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, ALL
  
  
  

1. GRANT (부여)

GRANT SELECT, INSERT, UPDATE, DELETE
 ON emp
TO username WITH GRANT OPTION;

GRANT SELECT, INSERT, UPDATE, DELETE
 ON emp
TO username WITH ADMIN OPTION;

2. REVOKE (회수)

REVOKE SELECT, INSERT, UPDATE, DELETE
 ON emp
TO username;