Re: Check if SELECT is granted

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Check if SELECT is granted
Date: 2005-09-02 21:15:35
Message-ID: 20050902211535.GA28989@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 02, 2005 at 10:39:14PM +0200, Poul Møller Hansen wrote:
> >
> >See the has_table_privilege() function.
>
> Thanks, but how does it work ?
>
> select has_table_privelege('public.mytable', 'select');
> ERROR: function has_table_privelege("unknown", "unknown") does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.

It helps if you spell "privilege" correctly ;-)

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hrishikesh Deshmukh 2005-09-02 21:28:11 Schema overlay question
Previous Message Matt Miller 2005-09-02 21:09:01 Re: Ora2Pg (was PL/pgSQL: EXCEPTION NOSAVEPOINT)