Even with autonomous transaction pragma it will NOT work!
-amar
Printable View
Even with autonomous transaction pragma it will NOT work!
-amar
Ok, I think I got it. Create a trigger that will write out a SQL file that contains your grants. Then use a java program to call an OS command. The OS command will call Sqlplus, which in turn calls your SQL file. Will this work?
P.S. I have the Java code, if you want it?