Sample Header Ad - 728x90

postgresql: permission denied for sequence <table>_i_seq

4 votes
4 answers
32168 views
I have a schema of a table in PostgreSQL that looks like: CREATE TABLE IF NOT EXISTS data.pmacct ( i BIGSERIAL PRIMARY KEY, And there are users: - **A**: superuser privileges - **B**: read/write privileges - **C**: read privileges And I have made the following modifications in regards to the privileges (as user **A**) CREATE SCHEMA data ; ALTER DATABASE ip_spotlight SET search_path TO data ; REVOKE EXECUTE ON ALL FUNCTIONS IN SCHEMA data FROM PUBLIC ; ALTER DEFAULT PRIVILEGES IN SCHEMA data GRANT SELECT ON TABLES TO C ; ALTER DEFAULT PRIVILEGES IN SCHEMA data GRANT ALL ON TABLES TO B ; as user postgres GRANT USAGE ON SCHEMA data TO netops ; GRANT USAGE ON SCHEMA data TO netopsapp ; GRANT SELECT ON ALL TABLES IN SCHEMA data TO C ; GRANT SELECT ON ALL SEQUENCES IN SCHEMA data TO C ; GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA data TO C ; GRANT ALL ON ALL TABLES IN SCHEMA data TO B ; GRANT ALL ON ALL SEQUENCES IN SCHEMA data TO B ; GRANT ALL ON ALL FUNCTIONS IN SCHEMA data TO B ; But I am getting the following error message as user **B** > ERROR: permission denied for sequence pmacct_i_seq Could you please enlighten me what I have done wrong and user **B** is not able to do an INSERT statement into the data.pmacct table ?
Asked by nskalis (1721 rep)
Nov 8, 2017, 12:38 PM
Last activity: Aug 1, 2023, 11:19 AM