Foreign Key References privilege.

[bkerr]

I am working with an Oracle 8.1.7 database, and am trying to create foreign keys where the master tables are held in a different schema to the child tables. I understand that the REFERENCES object privilege must be granted to the schema of the child table for each parent table. However, I was wondering if there is a way to grant references on a schema rather that each individual table. Otherwise I have to keep track of individual references grants on each table. Does anyone know of a way of doing this?

Many thanks,
Brendan.

[pando]

Grant to a role then grant that role to any user who needs to references the table. With roles it's much easier to manage privileges in a multi schema environment