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 has_table_privilege() function. See also information schema views whose names contain the word "grants" or "privileges." http://www.postgresql.org/docs/8.1/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE http://www.postgresql.org/docs/8.1/interactive/information-schema.html (Adjust the version number in the above links if you're using a version other than 8.1) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match