Drop Foreign Keys

[rpardip]

I have 2 users in the database, userA and userB.
UserB has the DML priviliges (SELECT, INSERT, UPDATE, DELETE) for all the tables under userA.

I was wondering if the userB can have DROP and CREATE FOREIGN KEYs of userA. If YES, what would be right GRANT command???

The reason is, for some cases in our application, userB has to delete certain data and to make FKs error simple, we want to DROP FKs, Delete the data, Insert new data, and re-create FKs.

Thanks in advance!

[sln81]

There is a grant "References". This can be given so that other user can create foreign keys

[marist89]

Why even have FK's if you are going to delete them to do your operation?

[rpardip]

sln81,

I would appreciate if you could give me the GRANT privilige
statement that you are talking about. I do not have access
to the docs from here.

[sreddy]

To grant BLAKE the REFERENCES privilege on the EMPNO column and the UPDATE privilege on the EMPNO, SAL, and COMM columns of the EMP table in the schema SCOTT, issue the following statement:

GRANT REFERENCES (empno), UPDATE (empno, sal, comm)
ON scott.emp
TO blake;