REVOKE

REVOKE deletes user IDs and removes permissions to specific users in a secured database.

Syntax

REVOKE CREATETAB 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 

public-or-user-group-name ::= PUBLIC | user-group-name 
user-group-name ::= user-name | group-name 
group-name ::= user-defined-name 
user-name ::= user-defined-name

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

This 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

REVOKE

Syntax

Examples

See Also