Search Postgresql Archives

Re: Permission; select currval('seq')

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes, that was the ticket; the commands I needed to
execute are as follows:

GRANT UPDATE ON  bla_bla_id_seq TO GROUP test_group_01;
GRANT SELECT ON  bla_bla_id_seq TO GROUP test_group_01;
GRANT INSERT ON  bla_bla_id_seq TO GROUP test_group_01;

Thanks!

--- On Sat, 1/2/10, Adrian Klaver <aklaver@xxxxxxxxxxx> wrote:
>
>
> 
> From here;
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
> 
> GRANT USAGE is for procedural languages and SCHEMA.
> 
> You will need to use the GRANT SELECT|INSERT ON  TABLE
> bla_bla_id_seq form. 
> Sequences being a type of table and not having their own
> GRANT form until later 
> versions.






-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux