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(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Cláudia Morgado" <claudia(dot)morgado(at)widesoft(dot)com(dot)br>
> Cc: <pgsql-general(at)postgresql(dot)org>; "Carla Mello"
> <carla(dot)mello(at)widesoft(dot)com(dot)br>
> Sent: Saturday, October 18, 2003 12:57 AM
> Subject: Re: [GENERAL] Help or Bug?
>
>
> > =?iso-8859-1?Q?Cl=E1udia_Morgado?= <claudia(dot)morgado(at)widesoft(dot)com(dot)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
>