Collections

      +

      Grant/Revoke Syntax Diagrams

      Grant Collection Diagram
      GRANT

      Example:

      GRANT SELECT, INSERT ON any COLLECTION TO USER user1, ROLE role1;
      GRANT SELECT, INSERT ON any COLLECTION IN DATABASE db TO USER user1, ROLE role1;
      GRANT SELECT, INSERT ON any COLLECTION IN SCOPE db.dv TO USER user1, ROLE role1;
      GRANT SELECT, INSERT ON COLLECTION col1 TO USER user1, ROLE role1;
      GRANT CREATE, DROP COLLECTION IN DATABASE db TO USER user1, ROLE role1;
      GRANT CREATE, DROP COLLECTION IN SCOPE db.dv TO USER user1, ROLE role1;
      Revoke Collection Diagram
      REVOKE

      Example:

      REVOKE SELECT, INSERT ON any COLLECTION FROM USER user1, ROLE role1;
      REVOKE SELECT, INSERT ON any COLLECTION IN DATABASE db FROM USER user1, ROLE role1;
      REVOKE SELECT, INSERT ON any COLLECTION IN SCOPE db.dv FROM USER user1, ROLE role1;
      REVOKE SELECT, INSERT ON COLLECTION col1 FROM USER user1, ROLE role1;
      REVOKE CREATE, DROP COLLECTION IN DATABASE db FROM USER user1, ROLE role1;
      REVOKE CREATE, DROP COLLECTION IN SCOPE db.dv FROM USER user1, ROLE role1;