Обсуждение: Is it possible to findout actual owner of table?

dipti shah <shahdipti1980@gmail.com> 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

dipti shah wrote:
> I don't want users to create/drop/alter anything directly. They have
> to use stored procedure for everything. The stored procedure creates
> logging tables and stores many other auditing information so it is
> madatory to prevent users from running any direct commands.
>

may be you should use middleware instead and not let your users connect
directly to SQL at all.

so, any DDL changes, you'd call the middleware server, it would
authenticate the user, decide whats allowed, maintain your audit trail,
logging, etc.  ditto, any operations that require database queries, etc,
would all be done by this middleware.

dipti shah wrote:
> What is middleware?

An application server that does all the business logic.  your user
software calls the application server to do things, and it in turn
accesses the database.    User written software is not alloweed to
directly connecct to the databases at all.   Classic example of a
middleware platform Apache Tomcat