Re: [GENERAL] User privileges on sequences

2001-10-17 Thread Peter Eisentraut
Mihai Gheorghiu writes: > Therefore, I have to give users permissions to sequences, just to the > extent that they could add records. What is the minimum set of > privileges for this? You need UPDATE privileges to be able to execute nextval() and currval(). I assume this would include setval() a

[GENERAL] User privileges on sequences

2001-10-16 Thread Mihai Gheorghiu
I have a db in which users can view and update data only via views. It is my understanding that the privileges of the view/rule creator do not extend to sequences. Therefore, I have to give users permissions to sequences, just to the extent that they could add records. What is the minimum set of p