Multiple users, same DB
Multiple users, same DB
От:
"Jeremy Buchmann" <jeremy@wellsgaming.com>
Дата:
Does anyone know how to create a postgresql user that can read/write to an existing database? I have used createuser, but it never asks if I want the new user to have access to an existing DB. When I connect to a DB with that new user, I can't read or write from any of the tables. Any suggestions? -- Jeremy Buchmann System Admin/Database Programmer Wells Gaming Research
Re: Multiple users, same DB
От:
John McKown <joarmc@swbell.net>
Дата:
On Tue, 12 Sep 2000, Jeremy Buchmann wrote: > Does anyone know how to create a postgresql user that can read/write to an > existing database? I have used createuser, but it never asks if I want the > new user to have access to an existing DB. When I connect to a DB with that > new user, I can't read or write from any of the tables. Any suggestions? > Logon as the database's owner. Now do a GRANT for the tables that the person should have access to. This is in the User's Guide, not the Administrator's Guide. John
Re: Multiple users, same DB
От:
"Anthony E . Greene" <agreene@pobox.com>
Дата:
On 12 Sep 2000 22:21 John McKown wrote: >On Tue, 12 Sep 2000, Jeremy Buchmann wrote: > >> Does anyone know how to create a postgresql user that can read/write to an >> existing database? I have used createuser, but it never asks if I want the >> new user to have access to an existing DB. When I connect to a DB with that >> new user, I can't read or write from any of the tables. Any suggestions? >> > >Logon as the database's owner. Now do a GRANT for the tables that the >person should have access to. This is in the User's Guide, not the >Administrator's Guide. Within psql, use \h grant To get help on the command. There should also be man pages on SQL commands in section l (lowercase "L"): man l grant man l revoke The man page is a lot more informative than the brief usage info given in psql. -- Anthony E. Greene PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D Linux. The choice of a GNU Generation.