On Thu, Feb 18, 2010 at 4:55 AM, dipti shah <shahdipti1980@gmail.com> wrote:
> Hi,
>
> I was looking for SQL DDL trigger kind of functionality in PostGreSQL but
> couldn;t find any.
There isn't any.
> Basically I want to make sure that no users
> should use "DROP" command directly on my database even though he/she owner
> of table or any database object. I want users to use stored procedures
> always to drop or alter the tables and any other database objects.
You could revoke their access to drop the objects and create SECURITY
DEFINER functions which do the drops. Then only grant execute access
to the people who should have had access to drop the objects in the
first place.
--
greg