pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Viewing access privileges
2+ messages / 2 participants
[nested] [flat]

* Viewing access privileges
@ 1999-01-16 09:00 Stephen Davies <scldad@sdc.com.au>
  1999-01-16 19:24 ` Re: [SQL] Viewing access privileges Tim J Trowbridge <trowbrid@execpc.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Stephen Davies @ 1999-01-16 09:00 UTC (permalink / raw)
  To: pgsql-sql

How can one view all of the access privileges of one or more users?

That is, how can I check what I have GRANTed to whom?

Also, where can I look to find answers to questions such as "what is the 
function that returns today's date for a default column value"?

Cheers and thanks,
Stephen Davies.


========================================================================
Stephen Davies Consulting	    		                            scldad@sdc.com.au
Adelaide, South Australia.     			                            Voice: 61-8-82728863
Computing & Network solutions.	 	                            Fax: 61-8-82741015





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Viewing access privileges
  1999-01-16 09:00 Viewing access privileges Stephen Davies <scldad@sdc.com.au>
@ 1999-01-16 19:24 ` Tim J Trowbridge <trowbrid@execpc.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tim J Trowbridge @ 1999-01-16 19:24 UTC (permalink / raw)
  To: pgsql-sql

Stephen Davies wrote:
> 
> How can one view all of the access privileges of one or more users?
> 
> That is, how can I check what I have GRANTed to whom?

Try this:
SELECT relname,relacl FROM pg_class WHERE relname !~ '^pg_';

-- 
Tim J Trowbridge                         trowbrid@writeme.com
Interested in my genealogy?          http://www.execpc.com/~trowbrid



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-01-16 19:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-16 09:00 Viewing access privileges Stephen Davies <scldad@sdc.com.au>
1999-01-16 19:24 ` Tim J Trowbridge <trowbrid@execpc.com>

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