PostgreSQL, how can i restrict access to code in a function for a user?

Question

I found out how to deny all access to tables for user in a schema.

REVOKE ALL PRIVILEGES ON SCHEMA test FROM user;

But what can i do to restrict access to all functions in a schema, so that user couldn't read the code?

I was trying this:

REVOKE ALL ON FUNCTION test.test_function(text) FROM user;

Yes, it has restricted the ability to change a function, but not to actually see it.

What have i missed?

score 2 · Accepted Answer · answered Sep 06 '10 at 13:18

2

REVOKE access to the system view pg_proc or at least the column prosrc that hase the source code for the function.

answered Sep 06 '10 at 13:18

Frank Heikens

i'm using here: REVOKE ALL PRIVILEGES ON TABLE pg_catalog.pg_proc FROM user; But it's not working... the user still can see the table. – m1nld3zz Sep 06 '10 at 14:09
1

Did you also REVOKE public access? Your user is also "public": REVOKE SELECT ON TABLE pg_proc FROM public; – Frank Heikens Sep 06 '10 at 14:57
can i revoke only a specific function ? – Abhijit Gujar Sep 01 '17 at 07:43

1 Answers1