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;