Privileges

For some database types, for pgCodeKeeper to work correctly, the user who is specified in the DB storage connection settings might need some extra privileges.

PosrgreSQL

PostgreSQL and Greenplum users don’t need any extra privileges.

When using the pg_dbo_timestamp extension, a user must have access to read the following objects:

GRANT USAGE ON SCHEMA schema_name TO user_name;
GRANT SELECT ON [schema_name.]dbots_object_timestamps TO user_name;

with schema_name being the schema where the extension is located

MS SQL

To get the metadata of the readable objects, you need the following privileges:

USE <DATABASE_NAME>;
GRANT VIEW DEFINITION ON DATABASE :: <DATABASE_NAME> TO <USER_NAME>;

ClickHouse

To get the metadata of the readable objects, you need the following privileges:

GRANT SHOW on *.* to role_name;
GRANT SHOW ACCESS on *.* to role_name;