Revoke and Rollback in SQL

Manish Sharma

14y1.9kSQL

Hi Friends

I want to know about Revoke and Rollback in SQL ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinitha T4y ago
Revoke falls under DCL (Data Control Language) command in SQL. DCL command is used to grant and take back authority from the database user.

Here Revoke is used to take back permission from user.

Syntax:
REVOKE privilege_name ON objectName FROM user;
here:
privilege_name -> SELECT / UPDATE / DELETE / INSERT / ALTER / ALL / CREATE
objectName -> Table Name
user -> User Name.

Rollback falls under TCL (Transaction Control Language) command in SQL. TCL commands manages transaction within the database.

Here Rollback is used to undo the changes i.e. it restores the database to last commited state.

Syntax:
ROLLBACK TO savePointName
Satyapriya Nayak14y ago
Hi Manish, Please refer the below links http://msdn.microsoft.com/en-us/library/ms187728.aspx, http://beginner-sql-tutorial.com/sql-grant-revoke-privileges-roles.htm, http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/rollback_statement.htm, http://databases.about.com/cs/administration/g/rollback.htm, http://msdn.microsoft.com/en-us/library/ms181299.aspx Thanks