Re: [GENERAL] Does a GRANT on a table cascade/implied to its SEQUENCES

2006-07-25 Thread Roderick A. Anderson
Tom Lane wrote: "Roderick A. Anderson" <[EMAIL PROTECTED]> writes: I've add a new user and as I go though granting various accesses to the different tables I realized many of those tables have primary keys that are generated by a sequence. Do I need to grant access on the sequences and what

Re: [GENERAL] Does a GRANT on a table cascade/implied to its SEQUENCES

2006-07-24 Thread Tom Lane
"Roderick A. Anderson" <[EMAIL PROTECTED]> writes: > I've add a new user and as I go though granting various accesses to the > different tables I realized many of those tables have primary keys that > are generated by a sequence. > Do I need to grant access on the sequences and what type of acce

[GENERAL] Does a GRANT on a table cascade/implied to its SEQUENCES

2006-07-24 Thread Roderick A. Anderson
I'm working on an application ( using Catalyst ) and realized I was using a user with too many privileges to access the database. I've add a new user and as I go though granting various accesses to the different tables I realized many of those tables have primary keys that are generated by a s