I'm having trouble GRANTing access on sequences. I created a database called 'asterisk' using the 'postgres' user. I then created 2 users called 'asterisk' and 'asterisk_owner'. I created a schema called 'asterisk' and GRANTed CREATE, DROP, INSERT, UPDATE, DELETE on this schema to 'asterisk_owner'. I signed in as 'asterisk_owner' and created some tables with primary keys based on sequences, then GRANTed SELECT, UPDATE, INSERT, DELETE on these tables to 'asterisk'. When I log in as 'asterisk', I can insert rows but I can't use the implied nextval(). It says the relation <seq_name> does not exist. When I do a \dp, I can see the sequence objects listed, but no permissions are listed. The tables have all the expected permissions. I couldn't see anything in the reference for the GRANT command for sequences. -- woody ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------
