2009/12/29 Tarun Sharma <tarun.sha...@newgen.co.in>: > hi > > when a superuser is logged in to the postgres server ,he has priveledge to > access all the databases. > > can we hide the structure of some of the databases from the superuser? > like if he gives command to open such a database the postgres may ask for > access password again.
You can use pg_hba.comf to lock down which database the superuser can access. And then have one superuser for each database, or something like that. But once you're in the database, you have full access. Which is a good reason to never hand out superuser privileges, yes :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
