I'm working on a project in which I need to determine which functions a given account has access to run.

So essentially, if I give this query an ID, can I get a list of functions that ID has access to execute.

Is this possible?

Thanks in advance.

  • PostgreSQL - sorry :D – RoflWaffle17 Oct 27 '17 at 13:59
  • Even if you can call the function, that doesn't mean you have the permission to run it successfully. Just fyi. A function can select from a table you do not have access to, or the like. – Evan Carroll Oct 27 '17 at 19:57
  • This is true @EvanCarrollQWERHJKL. I guess I should have made that understanding clear. – RoflWaffle17 Oct 30 '17 at 19:05

Sounds to me as if you are looking for:

select *
from information_schema.routine_privileges
where grantee = 'arthur';


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.