raghavendra t <raagavendra.rao@xxxxxxxxx> writes: > How to give security to the pg_catalogs, as these are freely alterable and > cause some security problem. Here i mean to say, as a superuser we can > delete the rows from a catalogs are alter the catalogs, is there anyway to > put restriction or any promting before doing anything to catalogs. > Any suggestions for this ? Don't give superuser privileges to anyone who's dumb enough to try such things on a production database. This is much like the fact that, say, root can trivially destroy any Unix filesystem. You could imagine trying to put enough training wheels on superuserdom to prevent such things, but it's not really practical and any attempt would get in the way of many legitimate uses. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
