Re: [GENERAL] Check if SELECT is granted

2005-09-03 Thread Poul Møller Hansen 


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



Thanks, stupud mistake ... :)

Poul


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [GENERAL] Check if SELECT is granted

2005-09-02 Thread Michael Fuhr 
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

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Check if SELECT is granted

2005-09-02 Thread Poul Møller Hansen 


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.



Poul

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Check if SELECT is granted

2005-09-01 Thread Tom Lane 
=?UTF-8?B?UG91bCBNw7hsbGVyIEhhbnNlbg==?= <[EMAIL PROTECTED]> writes:
> I'm wondering if it's possible for the ordinary user to check if SELECT
> is granted on a give table, without doing the select ?

See the has_table_privilege() function.

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[GENERAL] Check if SELECT is granted

2005-09-01 Thread Poul Møller Hansen 

I'm wondering if it's possible for the ordinary user to check if SELECT
is granted on a give table, without doing the select ?

I want to use it in an application with a menu structure, where I only
want to enable those options where SELECT on a the tables used in the 
given menu is granted.

Instead of keeping track on it in a separate table.


Thanks,
Poul

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster