| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | blindsey(at)cog(dot)ufl(dot)edu |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Grant question - More |
| Date: | 2004-01-29 19:45:59 |
| Message-ID: | 200401291645.59995.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El Jue 29 Ene 2004 16:26, Barbara Lindsey escribió:
> What permission does a user need to have to query the pg_ tables
> (pg_attribute, pg_class, etc) ? Do they require special permissions?
What kind of queries? Read or Write?
Users have permission to read from most catalog tables. One they can't read
for security resons is pg_shadow:
prueba=> select * from pg_shadow;
ERROR: pg_shadow: permission denied
Saludos... :-)
--
16:44:01 up 64 days, 23:00, 3 users, load average: 0.46, 0.38, 0.30
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-29 20:02:31 | Re: Planner configuration |
| Previous Message | Brendan Jurd | 2004-01-29 19:36:25 | Re: Update Default |