pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedget PGDATA as non-postgres user
2+ messages / 2 participants
[nested] [flat]
* get PGDATA as non-postgres user
@ 2008-01-03 12:15 Sofer, Yuval <Yuval_Sofer@bmc.com>
0 siblings, 1 reply; 2+ messages in thread
From: Sofer, Yuval @ 2008-01-03 12:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: get PGDATA as non-postgres user
@ 2008-01-03 12:56 Peter Eisentraut <peter_e@gmx.net>
parent: Sofer, Yuval <Yuval_Sofer@bmc.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2008-01-03 12:56 UTC (permalink / raw)
To: pgsql-admin; +Cc: Sofer, Yuval <Yuval_Sofer@bmc.com>
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-01-03 12:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-03 12:15 get PGDATA as non-postgres user Sofer, Yuval <Yuval_Sofer@bmc.com>
2008-01-03 12:56 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox