Progress
SQL-89
Guide and Reference


GRANT Statement

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

SYNTAX
GRANT
  {    ALL [ PRIVILEGES ] 
     | [ SELECT ] [ INSERT ] [ DELETE ]
       [ UPDATE  [ ( column-list ) ] ]
  }
  ON table-name TO { grantee-list | PUBLIC }
    [ WITH GRANT OPTION ] 

ALL [ PRIVILEGES ]

Grants all privileges that the granting user has (SELECT, INSERT, DELETE, and UPDATE) to the specified users.

SELECT

Grants the SELECT (_can-read) privilege to the specified users.

INSERT

Grants the INSERT (_can-create) privilege to the specified users.

DELETE

Grants the DELETE (_can-delete) privilege to the specified users.

UPDATE [ (column-list) ]

Grants the UPDATE (_can-write) privilege to the specified users. You can list the columns that the user can update. If you specify the keyword UPDATE but omit the column list, the grantees can update all columns of the specified table.

The syntax of column-list is as follows.

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

ON table-name

Represents the name of the table or view where you want to grant privileges.

TO { grantee-list | PUBLIC }

Represents the users to whom you want to grant privileges. You can specify a list of user names or the keyword PUBLIC, which grants the privileges to all users.

The syntax of grantee-list is as follows.

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

WITH GRANT OPTION

Grants the recipient of the privileges the right to grant those privileges to other users, and to revoke the privileges from anyone except the owner of the table. If this option is omitted, the recipient cannot grant the privileges to other users.

EXAMPLES

The following example grants privileges to retrieve, insert, and update employee information to user nancy. This also gives nancy the ability to grant privileges on the table to other users.

GRANT ALL PRIVILEGES
  ON Employee
  TO nancy
  WITH GRANT OPTION 

The following example grants the privilege to retrieve doc information to public users.

GRANT SELECT              
  ON Doc
  TO PUBLIC. 

The following example updates the grant of the employee information to users alan, bob, and kathy.

GRANT SELECT, INSERT, UPDATE    
  ON Employee
  TO alan, bob, kathy. 

NOTE

SEE ALSO

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


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