REVOKE

REVOKE deletes user IDs and removes permissions to specific users in a secured database. You can use the REVOKE statement to revoke CREATE TABLE, CREATE VIEW, and CREATE PROCEDURE privileges.

Syntax

REVOKE CREATETAB | CREATEVIEW | CREATESP FROM public-or-user-
group-name [ , public-or-user-group-name ]... 
REVOKE LOGIN FROM user-name [ , user-name ]...  
REVOKE table-privilege ON < * | table-name [ owner-name ]>  
FROM user-or-group-name [ , user-or-group-name ]... 

table-privilege ::=	   ALL 
| SELECT [ ( column-name [ , column-name ]... ) ] 
| UPDATE [ ( column-name [ , column-name ]... ) ] 
| INSERT [ ( column-name [ , column-name ]... ) ] 
| DELETE 
| ALTER 
| REFERENCES 

table-name ::= [database-name.]user-defined table name  
database-name ::= name of the database to which the table 
belongs 
public-or-user-group-name ::= PUBLIC | user-group-name 
user-group-name ::= user-name | group-name 
user-name ::= user-defined-name 
group-name ::= user-defined-name

The following table shows the syntax for a given action:


To REVOKE Privileges For This Action	Use This Syntax with REVOKE
CREATE TABLE	CREATETAB
CREATE VIEW	CREATEVIEW
CREATE PROCEDURE	CREATESP

Examples

The following statement revokes all these privileges from dannyd for table Class.

REVOKE ALL on Class from 'dannyd'

The following statement revokes all privileges from dannyd and travisk for table Class.

REVOKE ALL on Class from dannyd, travisk

The following statement revokes DELETE privileges from dannyd and travisk for table Class.

REVOKE DELETE on Class from dannyd, travisk

The following example revokes INSERT rights from keithv and miked for table Class.

REVOKE INSERT ON Class from keithv, miked

The following example revokes INSERT rights from keithv and brendanb for table Person and columns First_name and Last_name.

REVOKE INSERT(First_name,Last_name) ON Person from 
keithv, brendanb

The following statement revokes ALTER rights from dannyd from table Class.

REVOKE ALTER ON Class from dannyd

The following example revokes SELECT rights from dannyd and travisk on table Class.

REVOKE SELECT ON Class from dannyd, travisk

The following statement revokes SELECT rights from dannyd and travisk in table Person for columns First_name and Last_name.

REVOKE SELECT(First_name, Last_name) ON Person from 
dannyd, travisk

The following example revokes UPDATE rights from dannyd and travisk for table Person.

REVOKE UPDATE ON Person ON dannyd, travisk

The following example revokes CREATE VIEW privileges from user1.

REVOKE CREATEVIEW FROM user1;

REVOKE

Syntax

Examples

See Also