Postgres Pro
Downloads
Home   >   mailing lists

Is it possible to findout actual owner of table? - Mailing list pgsql-general

From dipti shah
Subject Is it possible to findout actual owner of table?
Date
Msg-id d5b05a951003082221y6416af68r7c9c6132469d785c@mail.gmail.com
Whole thread Raw
Responses Re: Is it possible to findout actual owner of table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi,
 
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?
 
Thanks,
Dipti

pgsql-general by date:

Previous
From: Sam Carleton
Date:
Subject: Re: managing tablespaces like files?
Next
From: Tom Lane
Date:
Subject: Re: Is it possible to findout actual owner of table?