David Legault escribió: > That's basically what I've done with my past questions on the ROLE system in > place. Since roles are global, I wanted it fine grained to the DB level so I > had to append DB_ in front of each role name and by using current_database() > inside my functions, I could hide that from the exterior.
Hmm, there used to be a facility to restrict users to specific databases, enabled by db_user_namespace (not by default). It seems to still work on 8.2 ... -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
