What is REVOKE?

What is REVOKE?

Rating:

REVOKE is a SQL statement that is used to revoke the privileges granted by using the GRANT statement. The syntax of the REVOKE statement is given below:

REVOKE
{ALL [PRIVILEGES] | permission [,...n]}
{
   [ (column [,...n] )] ON {table | view}
   | ON {table | view} [(column [,...n])]
   | ON {stored_procedure | extended_procedure}
   | ON {user_defined_function}
}
{TO | FROM}
   security_account [,...n]
[CASCADE]
[AS {group | role}];

Rating: