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;