| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | pgsqlnovice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Information schema question |
| Date: | 2005-02-04 13:37:50 |
| Message-ID: | F6842CBA-76B1-11D9-8DF0-000D933565E8@mail.nih.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
If I want to get, for example, all of the "user-defined" functions that
are available for execution by the current user, how could I go about
that? I see how to grab these for any given schema, but how can I tell
what schemas the current user has access to if the user can execute the
function? I thought I could use the routine_privileges view, but it
doesn't seem to have functions that I create in it--do I have to
explicitely grant execute on all functions for them to show up in
routine_privileges?
Thanks,
Sean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2005-02-04 13:51:45 | Re: Using a preprocessor for constants in SQL |
| Previous Message | Arthur van Dorp | 2005-02-04 13:30:00 | Using a preprocessor for constants in SQL |