Re: [GENERAL] How to give security to pg_catalogs

2010-03-29 Thread raghavendra t
Hi Tom, Thank you for the update > 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 man

Re: [GENERAL] How to give security to pg_catalogs

2010-03-29 Thread Tom Lane
raghavendra t 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 an

[GENERAL] How to give security to pg_catalogs

2010-03-29 Thread raghavendra t
Hi All, 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. An