| From: | "Kevin Schachter" <kevin(at)kevinity(dot)com> | 
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | Granting Permissions to User To Access Database | 
| Date: | 2001-01-06 20:42:28 | 
| Message-ID: | 001101c07821$323a2860$0300a8c0@kevin | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
I recently installed Postgres on my server to rid of the horrible
limitations of Mysql. However I am having some trouble setting up
permissions as they are in MySQL.
In MySQL you can grant a user select permissions to all tables in a database
with the command "GRANT select on db.* to .....". Is there a similar way to
accomplish this in Postgres? Reading up on GRANT I see that it only works
for individual tables and not a full database.
As well, how can I restrict a user to only one database. In pg_hba.conf
there is nothing that specifies the user name. I can grant access to the
database to all users on an ip, but I can't grant it to only one user.
Thanks in advance,
Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-06 21:48:10 | Re: install on Solaris | 
| Previous Message | Kevin Schachter | 2001-01-06 20:22:46 | Granting Permissions to User To Access Database |