Re: Insufficient Privileges

You cannot create permanent object with grants based on roles. DBA is a role. Have access to the AM table granted to you (user) directly - not via a role

Christopher Hurley wrote:

> I am trying to create foreign key relationships for an originating table in
> one schema and the referencing table in another schema. From the
> documentation, it appears that using the schema.table notation should work,
> but I am running into privilege problems. I do not own the objects, but I
> am logged in with the DBA Role and I tried to execute the following command:
>
> ALTER TABLE TM.TM_TRANSACTION
> ADD ( CONSTRAINT TMTRANS_AMPURSEITEM_FK
> FOREIGN KEY (SOURCE_PURSEITEM_ID)
> REFERENCES AM.AM_PURSE_ITEM )
>
> The error I get is:
> REFERENCES AM.AM_PURSE_ITEM )
> *
> ERROR at line 4:
> ORA-01031: insufficient privileges
>
> After receiving that error, I tried granting object privileges (to the DBA
> user) on the two tables (first just the alter and references privileges, but
> then all table privileges on the two tables in question), but received the
> same error. Any suggestions?
  Received on Tue Oct 24 2000 - 15:31:36 CDT