Access Restriction - 03-21-2007 , 05:29 AM
I have a datasource. Hmm, well first of all, what is the proper term for
postgres? its not database because there are "database' inside of it.
Anyway, I have a "database" on localhost. In it I have a few "Databases",
'db1', and 'production.' I want to restrct access to these databases to
only select users or groups. but there does not seem to be a way. All I
can do is restrict certain table access.
I want 'waduser' to be able to modify data within tables only. I want
'wadadmin' to be able to add/remove tables from the database.
What is the proper way to achieve this? Also is there any good book on
postgres security maybe?