ldap2pg: I am owner in the database and schema but i can't view the tables

I am owner in the database and schema but i can’t view the tables. In the ldap2pg.yml i put myself in the group owner. When i log in to the database i can create a new table in the schema, but i can’t view the table that i created.

CREATE TABLE myschema.accounts27 ( user_id serial PRIMARY KEY, username VARCHAR ( 50 ) UNIQUE NOT NULL, password VARCHAR ( 50 ) NOT NULL, email VARCHAR ( 255 ) UNIQUE NOT NULL, created_on TIMESTAMP NOT NULL, last_login TIMESTAMP ); CREATE TABLE

\d accounts27 ERROR: permission denied for table pg_class

ldap2pg.yml

ldap2pg.yml ``` yml ... ```

grant:

  • privilege: ro role: mygroup_readers database: mydatabase schema: myschema
  • privilege: rw role: mygroup_writers schema: myschema database: mydatabase
  • privilege: ddl role: mygroup_owners schema: myschema database: mydatabase

About this issue

  • Original URL
  • State: closed
  • Created 3 years ago
  • Comments: 36 (18 by maintainers)

Most upvoted comments

@diegodblr De nada 😃