SQL$HELP72.HLB  —  REVOKE  Arguments  POSITION n
    Specifies the position of the entry within the ACL. If you omit
    the AFTER or POSITION argument, SQL searches the entire ACL
    for an identifier list that matches the one specified in the
    FROM clause of the REVOKE statement. If it finds a match, it
    modifies the ACL entry by deleting the privileges specified in
    the privilege list. If there is no match, SQL generates an error
    and the REVOKE statement has no effect on the ACL.

    With the AFTER or POSITION argument, you can specify the position
    in the list from which SQL searches for an ACL entry with an
    identifier that matches the one specified in the FROM clause of
    the REVOKE statement.

    o  In the AFTER argument, the identifier specifies the entry in
       the ACL after which SQL begins its search for the entry to be
       modified or deleted. If none of the entries in the ACL has an
       identifier that matches the identifier specified in the AFTER
       argument, SQL generates an error and the statement fails.

       Starting after the entry specified by the identifier in the
       AFTER argument, SQL searches entries in the ACL. If an entry
       has an identifier that matches the identifier specified by the
       FROM clause of the REVOKE statement, SQL modifies or deletes
       that ACL entry.

       If none of the entries has an identifier that matches the
       identifier specified by the FROM clause of the REVOKE
       statement, SQL generates an error and the statement fails
       (even if an entry before the position at which SQL began its
       search had an identifier that matched).

       Specifying PUBLIC is equivalent to a wildcard specification of
       all user identifiers.

    o  In the POSITION argument, the integer specifies the earliest
       relative position in the ACL of the entry to be modified or
       deleted. If the integer is larger than the number of entries
       in the ACL, SQL generates an error and the statement fails.

       Starting with the position specified by the POSITION argument,
       SQL searches entries in the ACL. If an entry has an identifier
       that matches the identifier specified by the FROM clause of
       the REVOKE statement, SQL modifies or deletes that ACL entry.

       If none of the entries has an identifier that matches the
       identifier specified by the FROM clause of the REVOKE
       statement, SQL generates an error and the statement fails
       (even if an entry before the position at which SQL began its
       search had an identifier that matched).
Close Help