Mensaje citado por Barbara Lindsey <[EMAIL PROTECTED]>: > What kind of grant do you need to give a user so that they can have > permission to do a "SELECT nextval(ID)" on a sequence? > I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables, > including the one that has the sequence, but the sequence query is > failing on permissions.
You have to give him grant permissons on the sequence, not only the table, as when you do a nextval(´sequece_name´) you are updating the value of the sequence. P.D.: Could there be some extra docs about this in the GRANT command manual: http://www.postgresql.org/docs/current/interactive/sql-grant.html It speeks about granting all kind of relations, but not sequences. Just a tip. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; ------------------------------------------------------- Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral ------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
