How to fix 0LP01: invalid_grant_operation in PostgreSQL

SELECT schemaname, tablename, tableowner FROM pg_tables WHERE tablename = 'your_table';
SELECT datname, spcname FROM pg_database JOIN pg_tablespace ON pg_database.spcname = pg_tablespace.spcname WHERE datname = 'your_database';

GRANT SELECT ON your_table TO your_user WITH GRANT OPTION;

SELECT * FROM information_schema.role_table_grants WHERE grantee = 'your_username';
SELECT * FROM information_schema.table_privileges WHERE grantee = 'your_username';

-- WRONG - This will fail with 0LP01
GRANT role_a TO role_a;

-- CORRECT - Grant role_a to a different role
GRANT role_a TO role_b;
GRANT role_a TO user_c;

-- For tables
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE my_table TO my_user;

-- For schemas
GRANT USAGE, CREATE ON SCHEMA my_schema TO my_user;

-- For databases
GRANT CONNECT, CREATE ON DATABASE my_database TO my_user;

-- For sequences
GRANT USAGE, SELECT, UPDATE ON SEQUENCE my_sequence TO my_user;

-- For roles
GRANT role_a TO user_b;

-- Check tables
SELECT * FROM information_schema.tables WHERE table_name = 'your_table';

-- Check schemas
SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'your_schema';

-- Check roles
SELECT rolname FROM pg_roles WHERE rolname = 'your_role';

-- Check if the object exists and you have any access
SELECT has_table_privilege('your_user', 'your_schema.your_table', 'SELECT');

SU postgres
psql -d your_database -c "GRANT SELECT ON your_table TO my_user;"