DCL
can u explain grant and revoke operations with example...?
View Answers
October 12, 2011 at 10:55 AM
GRANT:
This command is used for gives access privileges to users for database. The syntax is-
GRANT dba to username;
REVOKE:
This command is used for withdraws access privileges to users for database. The syntax is-
REVOKE permissions on tablename from username;
Related Tutorials/Questions & Answers:
Common SQL Commands definition language), TCL (Tranction control language) and
DCL (Data control
language... is-
ROLLBACK;
4.
DCL COMMANDS
GRANTThis command is used for gives
Advertisements
SQL Plus used to query the relational database(DML,
DCL,DDL). SQL*PLUS commands are used