Re: [GENERAL] Check if SELECT is granted

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

Re: [GENERAL] Check if SELECT is granted

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

Re: [GENERAL] Check if SELECT is granted

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

[GENERAL] Check if SELECT is granted

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.

Re: [GENERAL] Check if SELECT is granted

=?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