From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Carel Combrink" <s25291930(at)tuks(dot)co(dot)za> |
Cc: | "PostgreSQL Novice List" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: User access |
Date: | 2010-09-23 16:36:47 |
Message-ID: | 16062.1285259807@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Carel Combrink" <s25291930(at)tuks(dot)co(dot)za> writes:
> I have a few schemas and would like to revoke access for a user on
> some functions and tables in the schema and grant access to other
> functions and tables in the schema.
> I have tried to grant the access to the functions but then when that
> user tries to call the funciton it says that he does not have access
> to the schema. So I've tried to GRANT USAGE on the schema but then the
> user have access to all the functions in the schema. So lastly I have
> treid to revoke usage from a function but the user can still call the
> function.
The default privileges on functions include public execute access.
To restrict usage of a function that's in an open schema, you'd need to
REVOKE EXECUTE ... FROM PUBLIC, then grant execute privilege to just the
people who should have it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-23 16:42:16 | Re: log options |
Previous Message | Tom Lane | 2010-09-23 16:14:42 | Re: ERROR: invalid input syntax for integer: "" |