| From: | Thomas Hallgren <thhal(at)mailblocks(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with access check |
| Date: | 2005-02-06 15:08:53 |
| Message-ID: | thhal-0isvhAm8GxicbFphin0yP1sUUWTqlsL@mailblocks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2005-02-06 15:33:30 | Re: [GENERAL] MySQL worm attacks Windows servers |
| Previous Message | Alvaro Herrera | 2005-02-06 14:45:18 | Re: Help with access check |