SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 08:18 AM
| ||||
| ||||
 get PGDATA as non-postgres user Hi I need to get PGDATA location when I logged in as non-postgres user. I cannot see data_directory from pg_setting table as non-postgres user. Any work around? Any other way to retrieve that information? If not, what is the quickest way to enable non-postgres user to have PGDATA location. Of course I can create table as postgres and grant select to the non-privileged user. But I wonder if there is a quicker solution. Thanks, Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuval_sofer@bmc.com      |
|
04-10-2008, 08:18 AM
| ||||
| ||||
| Re: get PGDATA as non-postgres user Am Donnerstag, 3. Januar 2008 schrieb Sofer, Yuval: > I need to get PGDATA location when I logged in as non-postgres user. Consider writing a security-definer function that retrieves the information. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
 |
« =?iso-2022-jp?B?GyRCJDMkcyRKSlEkSk02JCRKfSRiJEokJCRIO1ckJCReJDkkMSRJGyhC?=
|
Re: Need some info on Postgresql »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:48 PM.
