Re: I have a problem to create a constraint referencing table in another schema

[1] removing the DBA role is not necessarily a problem, you could could create similar roles yourself
[2] to be able to reference a table you (i.e. the table owner) need to grant the REFERENCES privilege to the user that needs it.

hth,
Peter

"Mathias Kluge" <software_at_dgateway-ger.com> schreef in bericht news:263641f3.0212090704.453736a0_at_posting.google.com...
> Hallo,
>
> the begin of the problem is, i will migrate the structure of a Sybase
> Adaptive Server Anywhere Database into ORACLE 8i(8.1.7)Personal
> Edition. On the Sybase DB exist 2 users. This users a contained all
> tables. One of that are calling "DBA". That user was my first problem
> on 8i. I must delete the role "DBA" to craete a user "DBA". Is it a
> problem, when the role "DBA" not exist?
>
> After that, i can create all tables with little adaptations on the
> column names and datatypes. When i will create a references from the
> schema "DBA" to another called "Heiko", i become the 'ORA-01031 -
> insufficient privileges' Error Message. The User "DBA" and "Heiko"
> have all system privileges.
>
> What is my problem? Who can help me?
> Thanks.
> Mathias
Received on Mon Dec 09 2002 - 09:14:02 CST