INSERT: It is used give an access to a user to add new records to the table.
SELECT: It is used give an access to a user to see the data from the table(s).
UPDATE: It allows a user to modify the records in the tables.
DELETE: It allows a user to remove the records in the tables.
GRANT SELECT, INSERT ON STUDENT TO AJIT; Or
GRANT ALL ON STUDENT TO AJIT;
The above statement grants the select and insert privileges on the STUDENT table to user
AJIT . In second statement all data manipulation permission on the table STUDENT are
given to user AJIT.
REVOKE statement is used to withdraw granted privileges to a user on an object.
Syntax of REVOKE command
REVOKE < Object privileges >
FROM < username>;
REVOKE SELECT, INSERT, UPDATE ON STUDENT FROM AJIT; SELECT,
INSERT and UPDATE privileges are taken back from user AJIT on table STUDENT.