Re: [SQL] permissions from system catalogs

2006-06-26 Thread Michael Fuhr
On Mon, Jun 26, 2006 at 05:30:12PM -0600, Kyle Bateman wrote: > Can anyone point me where to look in the system catalogs (or information > schema) to determine in advance whether a given user (or the current > user) will have select permission to a given table or view? An easy way is to use the

Re: [SQL] permissions from system catalogs

2006-06-26 Thread Tom Lane
Kyle Bateman <[EMAIL PROTECTED]> writes: > Can anyone point me where to look in the system catalogs (or information > schema) to determine in advance whether a given user (or the current > user) will have select permission to a given table or view? Try has_table_privilege() http://www.postgresq

[SQL] permissions from system catalogs

2006-06-26 Thread Kyle Bateman
Can anyone point me where to look in the system catalogs (or information schema) to determine in advance whether a given user (or the current user) will have select permission to a given table or view? Kyle ---(end of broadcast)--- TIP 6: explai