Postgres Pro
Downloads
Home   >   mailing lists

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

From dipti shah
Subject Re: Is it possible to findout actual owner of table?
Date
Msg-id d5b05a951003082335s44945af5u34ebf948d5b89c84@mail.gmail.com
Whole thread Raw
In response to Re: Is it possible to findout actual owner of table?  (John R Pierce <pierce@hogranch.com>)
Responses Re: Is it possible to findout actual owner of table?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
What is middleware?
 
Is it similar to stored procedure? That what I have been doing. I have revoked all permissions from mydb schema from public and have SECURITY DEFINER enable for stored procedure to allow creating/droping/altering tables.
 
Thanks.

On Tue, Mar 9, 2010 at 12:19 PM, John R Pierce <pierce@hogranch.com> wrote:
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.





pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: kernel version impact on PostgreSQL performance
Next
From: John R Pierce
Date:
Subject: Re: Is it possible to findout actual owner of table?