-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|