pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
get 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