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)
@diegodblr De nada 😃