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.
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.
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.
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.
EXAMPLESThe 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.
The following example grants the privilege to retrieve doc information to public users.
The following example updates the grant of the employee information to users alan, bob, and 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 |