Alvaro Herrera wrote:
On Sun, Feb 06, 2005 at 03:28:31PM +0100, Thomas Hallgren wrote:
Hi,
From code inside a C-function, given the AclId of a user and the Oid of
a Schema, what's the most efficient way to find out if the user has been
granted CREATE on the schema?
See src/backend/catalog/aclchk.c, function pg_namespace_aclcheck().
Great. Thanks!
Why would you want to do that directly anyway?
In PLJava, I use a function to set a schema specific Java classpath that
functions declared in that schema will use. The setting is permanent
(i.e. not per session). I want to prevent all users but those that have
create permission on the schema to set this classpath.
Regards,
Thomas Hallgren
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
