Postgres Pro
Downloads
Home   >   mailing lists

Re: Does the current user have UPDATE privilege on FOO? - Mailing list pgsql-general

From Mike Blackwell
Subject Re: Does the current user have UPDATE privilege on FOO?
Date
Msg-id CANPAkgvfF5md+jf7awjsSV6AAhFprE4N3EB0GaA0hw2h_Spw2g@mail.gmail.com
Whole thread Raw
In response to Does the current user have UPDATE privilege on FOO?  (Lionel Elie Mamane <lionel@mamane.lu>)
Responses Re: Does the current user have UPDATE privilege on FOO?  (Lionel Elie Mamane <lionel@mamane.lu>)
List pgsql-general
Tree view
On Mon, Feb 27, 2012 at 11:00, Lionel Elie Mamane <lionel@mamane.lu> wrote:
Hi,

I'm trying to understand the "clean" way to determine whether the
current role has UPDATE (or SELECT or DELETE or UPDATE) privileges on
a specific table (or column). If I can do it in a way that is portable
across different DBMSs, even better :)


For PostgreSQL only, see http://www.postgresql.org/docs/9.1/interactive/functions-info.html for a list of functions for this.

Mike 

pgsql-general by date:

Previous
From: Ireneusz Pluta
Date:
Subject: pg_class.relnamespace NOT IN pg_namespace.oid
Next
From: Adrian Klaver
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1