................................................................................318 18.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

................................................................................317 18.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

................................................................................335 18.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

................................................................................335 18.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

............................................................................... 730 21.3. Role Membership ............................................................................... 732 21.4. Dropping other native and user-defined oper- ators BETWEEN IN LIKE ILIKE SIMILAR range containment, set membership, string matching < > = <= >= <> comparison operators IS ISNULL NOTNULL IS TRUE, IS FALSE SELECT, INSERT, UPDATE, or DELETE. Multiple roles can be assigned to a given policy, and normal role membership and inheritance rules apply. To specify which rows are visible or modifiable according to a policy

............................................................................... 771 21.3. Role Membership .................................................................................... 773 21.4. other native and user-defined opera- tors BETWEEN IN LIKE ILIKE SIMILAR range containment, set membership, string matching < > = <= >= <> comparison operators IS ISNULL NOTNULL IS TRUE, IS FALSE SELECT, INSERT, UPDATE, or DELETE. Multiple roles can be assigned to a given policy, and normal role membership and inheritance rules apply. 87 Data Definition To specify which rows are visible or modifiable

................................................................................413 19.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment 31 Chapter 4. SQL Syntax Operator/Element Associativity Description desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

................................................................................390 19.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching desired access privilege type must evaluate to MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of

............................................................................... 709 22.3. Role Membership ............................................................................... 711 22.4. Dropping Operator/Element Associativity Description BETWEEN IN LIKE ILIKE SIMILAR range containment, set membership, string matching < > = <= >= <> comparison operators IS ISNULL NOTNULL IS TRUE, IS FALSE SELECT, INSERT, UPDATE, or DELETE. Multiple roles can be assigned to a given policy, and normal role membership and inheritance rules apply. To specify which rows are visible or modifiable according to a policy

................................................................................467 20.4. Role Membership .............................................................................................. NOTNULL test for not null (any other) left all other native and user-defined operators IN set membership BETWEEN range containment OVERLAPS time interval overlap LIKE ILIKE SIMILAR string pattern matching type must evaluate to some combi- nation of MEMBER or USAGE. MEMBER denotes direct or indirect membership in the role (that is, the right to do SET ROLE), while USAGE denotes whether the privileges of