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