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
Last activity: Aug 1, 2023, 11:19 AM