Page 88 - Computer Software Application TP - Volume 1
P. 88
COMPUTER SOFTWARE APPLICATION - CITS
4 Drop Table:
DROP TABLE employees;
TASK 3 : DCL (Data Control Language) Statements:
1 GRANT: Assigns permissions to users on databases and objects.
GRANT SELECT, INSERT ON customers TO user1@localhost;
2 REVOKE: Removes permissions from users.
If we want to revoke all privileges assign to the user, execute the following statement:
REVOKE ALL, GRANT OPTION FROM john@localhost;
REVOKE INSERT ON customers FROM user1@localhost;
73
CITS : IT & ITES - Computer Software Application - Exercise 23