Granting the REFERENCES Privilege on Tables

Grant the privilege to indexes and to foreign keys on a table. This privilege does not apply to views. This privilege can be restricted to a set of columns in the table.

Prerequisites

Requires one of:

You have been granted the MANAGE ANY OBJECT PRIVILEGE system privilege.
You have been granted the REFERENCE object privilege on the table with the WITH GRANT OPTION clause.
You own the table.

Task

To grant the REFERENCES privilege, enter:

GRANT REFERENCES column_name 
  ON table_name
  TO userID [,...]

Example:

This statement grants the REFERENCES privilege to user Joe on columns Col_1 and Col_2 in the table named sales_table:

GRANT REFERENCES Col_1, Col_2 ON sales_table
TO Joe