Re: 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.

Thanks very much.
We resolve this problem with the permission
----- 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