Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training Big Data and Hadoop Training Java Training  
 

DCL

Ads

 
 

Share on Google+Share on Google+

sowmya k c
DCL
1 Answer(s)      5 years and 10 months 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;

Ads









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).