[lug] postgres question

rm at fabula.de rm at fabula.de
Thu Nov 13 05:31:40 MST 2003

On Wed, Nov 12, 2003 at 11:40:57PM -0700, dan radom wrote:
> [...] 
> Nah.  I do that all the time.  Here's a snippit from a sql file ...
> GRANT ALL on lostfound_id_seq,screenshots_id_seq,pictures_id_seq,downloads_id_seq,users_id_seq to graffix;
> It works just fine and does in fact grant the appropriate premissions.

Yes, but you GRANT on a list of database objects, _not_ on the database
per se. This is, IMHU the right thing to do, but i have to admit that it
can get rather clumsy if your database holds a lot of tables/sequences etc.

 Ralf Mattes

> Does the user in fact exist?  \du from psql will show you the users.
> Perhaps you need to CREATE USER foo; first?  What version of postgres ..
> SELECT version(); just in case :)
> dan
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug

More information about the LUG mailing list