Regarding Creating References in Databases for Foreign Key constraints
Dear All,
Can anyone let me know how we can grant REFERENCES Privilege across the system. For Eg: We have a user A and this user should have permission to be able to create table along with references in another schema. All I'm aware of is of granting CREATE ANY TABLE and ALTER ANY TABLE. But, with ALTER ANY TABLE still i'm unable to use REFERENCE.
Can anyone let me know how we can grant REFERENCES Privilege across the system. For Eg: We have a user A and this user should have permission to be able to create table along with references in another schema. All I'm aware of is of granting CREATE ANY TABLE and ALTER ANY TABLE. But, with ALTER ANY TABLE still i'm unable to use REFERENCE.
0