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 

See Also

GRANT