Re: Does a user have usage on a schema?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Does a user have usage on a schema?
Date: 2005-06-29 15:36:35
Message-ID: 20050629153635.GA5571@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jun 29, 2005 at 08:57:32 -0600,
"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> wrote:
> 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?

The has_schema_privilege function will allow you to check if a user
has access to a schema. You can use pg_users to get a list of all
users and pg_namespace can be used to get a list of all schemas.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Walker, Jed S 2005-06-29 15:59:06 Re: Does a user have usage on a schema?
Previous Message Andreas Kretschmer 2005-06-29 15:16:35 Re: [despammed] Does a user have usage on a schema?