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: | Raw Message | Whole Thread | 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 |