Scopes

    Grant/Revoke Syntax Diagrams

    Grant Scope Diagram
    GRANT

    Example:

    GRANT CREATE, DROP SCOPE TO USER user1, ROLE role1;
    GRANT CREATE, DROP SCOPE IN DATABASE db TO USER user1, ROLE role1;
    Revoke Scope Diagram
    REVOKE

    Example:

    REVOKE CREATE, DROP SCOPE FROM USER user1, ROLE role1;
    REVOKE CREATE, DROP SCOPE IN DATABASE db FROM USER user1, ROLE role1;