dipti shah <shahdipti1980@xxxxxxxxx> writes: > I have created the stored procedure that allows particular users to create > the table. I want to prevent users to drop the tables owned by someone esle > and hence, I am making owner of each table created by this stored procedure > to super user(postgres) so that no one will be allowed to drop/alter table. > I want to allow to drop/alter the table by actuall user who ran the stored > procedure to create the table. Could anyone please suggest me how to proceed > with this? It sounds like you are going to a great deal of trouble to reinvent the standard behavior. Why not forget the stored procedure and just let users create and drop their own tables? 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
