Progress
SQL-89
Guide and Reference


REVOKE Statement

Allows the owner or any user who holds the GRANT OPTION on a table or view to revoke privileges on that table or view.

SYNTAX
REVOKE
  {   ALL [ PRIVILEGES ] 
     | [ SELECT ] [ INSERT ] [ DELETE ]
       [ UPDATE [ ( column-list ) ] ]
  }
ON table-name FROM { grantee-list | PUBLIC } 

ALL [ PRIVILEGES ]

Revokes all privileges that the revoking user has (SELECT, INSERT, DELETE, and UPDATE) from the specified users. This only revokes the privileges that the user has.

SELECT

Revokes the SELECT privilege from the specified users.

INSERT

Revokes the INSERT privilege from the specified users.

DELETE

Revokes the DELETE privilege from the specified users.

UPDATE [ (column-list) ]

Revokes the UPDATE privilege from the specified users. You can list the columns for which to revoke the UPDATE privilege. If you specify the keyword UPDATE, but omit the column list, the UPDATE privilege is revoked on all columns of the specified table.

The syntax of column-list is as follows.

SYNTAX
    column-name [ , column-name ] ... 

ON table-name

Indicates the name of the table or view to revoke privileges.

FROM { grantee-list | PUBLIC }

Identifies the users from which you want to revoke privileges. You can specify a list of user names or the keyword PUBLIC which revokes the privileges from all users.

The syntax of grantee-list is as follows.

SYNTAX
    user-name [ , user-name ] ... 

EXAMPLES

The following example revokes SELECT permissions for the public on the doc view.

REVOKE SELECT  
  ON Doc
  FROM PUBLIC. 

The following example revokes INSERT and UPDATE permissions for kathy on the employee table.

REVOKE INSERT, UPDATE          
  ON Employee
  FROM kathy. 

NOTES

SEE ALSO

ALTER TABLE Statement, CREATE SCHEMA Statement (ESQL Only), CREATE TABLE Statement,CREATE VIEW Statement, DROP TABLE Statement, DROP VIEW Statement, GRANT Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095