sowmya k c
DCL
1 Answer(s)      5 years ago
Posted in : SQL

can u explain grant and revoke operations with example...?

Ads

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:
DCL
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
the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query
JDBC Training, Learn JDBC yourself
language) and DCL (Data control language).   Using JOINING
JDBC - Java Database Connectivity Tutorial
) and DCL (Data control language).       

Ads

Advertisement