1.1.1

ManualsBrandsVMware ManualsApplicationsvFabric SQLFire

541

542

543

544

545

546

547

548

549

550

Table Of Contents

The following types of permissions can be revoked:

• DML operations permissions on a speciﬁc table.

• Insert/Delete data to/from a speciﬁc table.

• Select/Update data permissions on a table or a subset of columns in a table.

• Create a foreign key reference to the named table or to a subset of columns from a table.

• Create a trigger permission on a table.

• Execute permission on a speciﬁed routine (function or procedure).

Before you issue a REVOKE statment, ensure that the sqlﬁre.sql-authorization property is set to "true," which

enables the SQL Authorization mode.

You can revoke privileges from an object if you are the owner of the object or the distributed member owner.

privilege-type

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

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

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

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

Use the REFERENCES privilege type to revoke 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 revoked on only the

foreign key reference to the speciﬁed columns.

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

column list is speciﬁed with the SELECT privilege, the permission is revoked 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 revoke permission to create a trigger on the speciﬁed table.

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

a column list is speciﬁed, the permission is revoked only on the speciﬁed columns.

grantees

You can revoke the privileges from speciﬁc users or from all users. Use the keyword PUBLIC to specify all

users.

The privileges revoked from PUBLIC and from individual users are independent privileges. For example, consider

the case where the SELECT privilege on table "t" is granted to both PUBLIC and to the authorization ID "harry."

If the SELECT privilege is later revoked from the authorization ID "harry," harry can still access table t using

the PUBLIC privilege.

Note: The privileges of the owner (distributed member) of an object cannot be revoked.

routine-designator

{ qualified-name [ signature ] }

Cascading Object Dependencies

For views, triggers, and constraints, if the privilege on which the object depends on is revoked, the object is

automatically dropped. SQLFire does not try to determine if you have other privileges that can replace the

privileges that are being revoked.

vFabric SQLFire User's Guide526

vFabric SQLFire Reference