Re: [despammed] Does a user have usage on a schema?

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [despammed] Does a user have usage on a schema?
Date: 2005-06-29 15:16:35
Message-ID: 20050629151635.GA6309@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 ===

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-29 15:36:35 Re: Does a user have usage on a schema?
Previous Message Tom Lane 2005-06-29 14:58:38 Re: Rule creation and evaluation order