am 29.06.2005, um 8:57:32 -0600 mailte Walker, Jed S folgendes:
> How can I query the database to determine if a user has usage on a
> particular schema, and how can I query the database to find out all the
> schemas a user has usage on?
start psql with -E and type "\n" to see all schemas and the underlaying
select. Now you can modify this select to select all schemas for a user.
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===