1.1.1

ManualsBrandsVMware ManualsApplicationsvFabric SQLFire

541

542

543

544

545

546

547

548

549

550

Table Of Contents

Privileges authorized to a user can only be granted by the user to others. See the CREATE statement for the

respective SQL object that you want to grant privileges on for more information.

privilege-type

ALL PRIVILEGES | privilege-list

Use the ALL PRIVILEGES privilege type to grant all of the permissions to the user for the speciﬁed table. You

can also grant one or more table privileges by specifying a privilege-list.

privilege-list

table-privilege {, table-privilege }*

table-privilege

DELETE | INSERT | REFERENCES [column-list] | SELECT [column-list] |

TRIGGER | UPDATE [ column-list ]

Use the DELETE privilege type to grant permission to delete rows from the speciﬁed table.

Use the INSERT privilege type to grant permission to insert rows into the speciﬁed table.

Use the REFERENCES privilege type to grant permission to create a foreign key reference to the speciﬁed table.

If a column list is speciﬁed with the REFERENCES privilege, the permission is valid on only the foreign key

reference to the speciﬁed columns.

Use the SELECT privilege type to grant permission to perform SELECT statements on a table or view. If a

column list is speciﬁed with the SELECT privilege, the permission is valid on only those columns. If no column

list is speciﬁed, then the privilege is valid on all of the columns in the table.

Use the TRIGGER privilege type to grant permission to create a trigger on the speciﬁed table.

Use the UPDATE privilege type to grant permission to use the UPDATE statement on the speciﬁed table. If a

column list is speciﬁed, the permission applies only to the speciﬁed columns. To update a row using a statement

that includes a WHERE clause, you must have SELECT permission on the columns in the row that you want to

update.

column-list

( column-identifier {, column-identifier }* )

grantees

{ authorization ID | PUBLIC } [,{ authorization ID | PUBLIC } ] *

You can grant privileges for speciﬁc users or for all users. Use the keyword PUBLIC to specify all users. When

PUBLIC is speciﬁed, the privileges affect all current and future users. The privileges granted to PUBLIC and

to individual users are independent privileges. For example, a SELECT privilege on table t is granted to both

PUBLIC and to the authorization ID harry. The SELECT privilege is later revoked from the authorization ID

harry, but Harry can access the table t through the PUBLIC privilege.

routine-designator

{ function-name | procedure-name }

523

SQL Language Reference