1.0

Examples
-- a Select expression
SELECT * FROM TRADE.CUSTOMERS
-- a subquery
SELECT * FROM TRADE.CUSTOMERS C WHERE EXISTS (SELECT * FROM
TRADE.PORTFOLIO F WHERE F.CID = C.CID AND TID =? AND F.QTY
>927)
-- a values expression
VALUES (1,2,3
-- avg always returns a single value, so the subquery is a
ScalarSubquery
SELECT S.CID FROM TRADE.SELLORDERS S WHERE (SELECT SUM(QTY)
FROM TRADE.PORTFOLIO F WHERE F.CID = S.CID GROUP BY F.CID) >
1277 AND TID =1
-- a subquery used with EXISTS
SELECT C.CID FROM TRADE.CUSTOMERS C WHERE EXISTS (SELECT *
FROM TRADE.PORTFOLIO F WHERE F.CID = C.CID AND TID = 1 AND
F.QTY >927)
-- a subquery used with IN
SELECT F.CID FROM TRADE.PORTFOLIO F WHERE F.CID IN (SELECT
CID FROM TRADE.CUSTOMERS C WHERE SINCE > ?)
-- a subquery used with a quantified comparison
SELECT S.CID FROM TRADE.SELLORDERS S WHERE (SELECT SUM(QTY)
FROM TRADE.PORTTOLIO F WHERE F.CID = S.CID GROUP BY F.CID) >
1231
REVOKE
Revoke privileges to a table or to a routine.
Syntax
The syntax used for the REVOKE statement differs depending on whether you revoke privileges to a table or
to a routine.
Syntax for Tables
REVOKE privilege-type ON [ TABLE ] { table-name | view-name } FROM grantees
If you do not specify a column list, the statement revokes the privilege for all of the columns in the table.
Syntax for Routines
REVOKE EXECUTE ON { FUNCTION | PROCEDURE } routine-designator FROM grantees
RESTRICT
You must use the RESTRICT clause on REVOKE statements for routines. The RESTRICT clause specifies that
the EXECUTE privilege cannot be revoked if the specified routine is used in a view, trigger, or constraint, and
the privilege is being revoked from the owner of the view, trigger, or constraint.
Description
The REVOKE statement removes permissions from a specific user or from all users to perform actions on
database objects.
The following types of permissions can be revoked:
vFabric SQLFire User's Guide482
vFabric SQLFire Reference