Page 88 - Computer Software Application TP - Volume 1

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