Thread: Help or Bug?

Tom Lane,

This problem was solved with the suggested permission.

GRANT USAGE ON SCHEMA wlog_data TO wlog_uni;

There is the possibility of us to consult the permission above in the
database?

Thanks very much,
Carla Mello and Cláudia Morgado.


> ----- Original Message -----
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> To: "Cláudia Morgado" <claudia.morgado@widesoft.com.br>
> Cc: <pgsql-general@postgresql.org>; "Carla Mello"
> <carla.mello@widesoft.com.br>
> Sent: Saturday, October 18, 2003 12:57 AM
> Subject: Re: [GENERAL] Help or Bug?
>
>
> > =?iso-8859-1?Q?Cl=E1udia_Morgado?= <claudia.morgado@widesoft.com.br>
> writes:
> > > CREATE SCHEMA wlog_data AUTHORIZATION wlog_data;
> > > ...
> > > 5=BA) Now We try to create the foreing key  :
> > > ERROR: wlog_data: permission denied
> >
> > I think you forgot to grant USAGE on the wlog_data schema to the other
> > user.  This permission bit doesn't have any equivalent in Oracle AFAIK,
> > but it corresponds to execute permission on a Unix directory, if that
> > helps you at all...
> >
> > regards, tom lane
>

On Monday 20 October 2003 16:19, Cláudia Morgado wrote:
> Tom Lane,
>
> This problem was solved with the suggested permission.
>
> GRANT USAGE ON SCHEMA wlog_data TO wlog_uni;
>
> There is the possibility of us to consult the permission above in the
> database?

SELECT * FROM pg_namespace ;

For tables, I'd use \dp in psql.

--
  Richard Huxton
  Archonet Ltd