DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Mar 2001
    Even with autonomous transaction pragma it will NOT work!


  2. #12
    Join Date
    Apr 2001
    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

Click Here to Expand Forum to Full Width