without haste but without rest

[DB] DCL 본문

Database

[DB] DCL

JinungKim 2020. 2. 6. 22:03

1. GRANT - 권한 부여

ex) GRANT ALL PRIVILEGES ON *.* TO 유저이름 IDENTIFIED BY '권한 부여자'

 

2. REVOKE

ex)  REVOEK ALL ON *.* FROM 유저이름

'Database' 카테고리의 다른 글

[DB] JOIN (EUQI, INNER, OUTER, FULL)  (0) 2020.02.06
[DB] WHERE, GROUP BY, HAVING, ORDER BY  (0) 2020.02.06
[DB] TCL  (0) 2020.02.06
[DB] DML  (0) 2020.02.06
[DB] DDL  (0) 2020.02.06
Comments