
November 17th, 2011, 05:10 PM
|
|
Registered User
|
|
Join Date: Dec 2004
Location: Mississauga, Canada
Posts: 5
Time spent in forums: 43 m 33 sec
Reputation Power: 0
|
|
Quote: | Originally Posted by mukris if the abc user have DBA privileges, you can give the GRANT PRIVS |
Thanks for the recommendation 
Since I had to get this done a while ago, I created a separate process which logs into the other (xyz) schema and then grants the privilege itself.
A bit of a pain in the ***, but not too bad
I'll give your recommendation a try, but just to satisfy my curiosity 
The project in question is already tested and modifying it would require more testing from QA, all they do is complain about resources, so that won't fly 
|