User Permissions

1. Granting Permissions

Granting permissions over resources is done through the SQL interface. You can execute your queries using your SQL client or the "Run SQL" When using the secured SQL access, you can manage the permissions over resources through the SQL interface, so that a certain user can grant read or write permission to other user over tables and sequences.

GRANT <permission lists> ON TABLE <table name> TO <user>
GRANT <permission lists> ON SEQUENCE <sequence name> TO <user>
GRANT <permission lists> ON SCHEMA <schema name/user> TO <user>
REVOKE <permission lists> ON TABLE <table name> TO <user>
REVOKE <permission lists> ON SEQUENCE <sequence name> TO <user>
REVOKE <permission lists> ON SCHEMA <schema name/user> TO <user>

The possible permissions are the following:

  • READ

    • Table permissions: Insert, Upsert, Update and Delete.

    • Sequence permissions: Next and Current Value.

  • WRITE

    • Table permissions: Select.

    • Sequence permissions: Select.

  • ALTER

    • Table permissions: Create, Drop, Grant and Revoke table permissions.

    • Sequence permissions: Create, Drop, Grant and Revoke sequence permissions.

2. Examples

Revoke all permissions to group members

revoke read, write, alter on table t to scigroup

Allow select on table

grant read on table t to tesla

Allow select on schema

grant read on schema einstein to tesla

Allow select, insert, update and delete

grant read, write on table t to tesla

Allow create, drop or truncate, grant or revoke

grant alter on table t to tesla