Re: Does the current user have UPDATE privilege on FOO?

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: Lionel Elie Mamane <lionel(at)mamane(dot)lu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does the current user have UPDATE privilege on FOO?
Date: 2012-02-27 18:11:23
Message-ID: CANPAkgvfF5md+jf7awjsSV6AAhFprE4N3EB0GaA0hw2h_Spw2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 27, 2012 at 11:00, Lionel Elie Mamane <lionel(at)mamane(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-27 18:54:27 Re: Having a problem with RoR-3.1.1 and Pg-9.1
Previous Message Ireneusz Pluta 2012-02-27 17:53:01 pg_class.relnamespace NOT IN pg_namespace.oid