Hello!
Good Morning!
My name´s Carla and I work how System Analyse in company Widesoft Sistemas.
Currently we work with the Oracle and we are studying a possible migration for the Postgre. However we are having problems to relate one different table of schemas.
It follows below the carried through stages:
(The database used is Postgres 7.1.4 for Linux)
1º) We created a database;
CREATE DATABASE DEVEL;
2º) We created two users;
CREATE USER wlog_data WITH PASSWORD 'xxx';
CREATE USER wlog_uni WITH PASSWORD 'yyy';
3º) We created two schemas and reationship with users.
CREATE SCHEMA wlog_data AUTHORIZATION wlog_data;
CREATE SCHEMA wlog_uni AUTHORIZATION wlog_uni;
4º) After, We conceded the permissions.
GRANT SELECT ON wlog_data.cr_messagetype_mul TO wlog_uni;
GRANT REFERENCES ON wlog_data.cr_messagetype_mul TO wlog_uni;
5º) Now We try to create the foreing key :
ALTER TABLE wlog_uni.cr_processload_pri ADD CONSTRAINT
FK_CR_PROCESSLOAD_CD_MESSAGE FOREIGN KEY
(CD_MESSAGE) REFERENCES wlog_data.cr_messagetype_mul
(CD_MESSAGE);
ERROR: wlog_data: permission denied
Somebody could help me?
Thanks,
-----------------------------------------------------------------------------------------
Carla Mello carla.mello@widesoft.com.br
Banco de Dados
Fone: (19) 3451-6300 www.widesoft.com.br
-----------------------------------------------------------------------------------------