Thread: system catalog
an user (not superuser) of any postgresql database can access to pg_user, pg_database , pg_stat_get_db_numbackends , ... is there any way of avoid this? i mean : only superuser could access to catalog and statisc views. ___________________________________________________ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es
Jose Antonio Martinez wrote: > an user (not superuser) of any postgresql database can > access to pg_user, pg_database , > pg_stat_get_db_numbackends , ... > > is there any way of avoid this? i mean : only > superuser could access to catalog and statisc views. IMHO backend process need access to system tables for system purpose (for planning query,etc) and it run with user permissions. So you can't avoid this. -- Olleg Samoylov
Jose Antonio Martinez writes: > an user (not superuser) of any postgresql database can > access to pg_user, pg_database , > pg_stat_get_db_numbackends , ... > > is there any way of avoid this? i mean : only > superuser could access to catalog and statisc views. Revoke the permissions. -- Peter Eisentraut peter_e@gmx.net