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
JDBC Training, Learn JDBC yourself
language) and DCL (Data control language).   Using JOINING
JDBC - Java Database Connectivity Tutorial
) and DCL (Data control language).       

Questions by Category