DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Assinging 'Select' previliges.

  1. #11
    Join Date
    Mar 2001
    Posts
    314
    Even with autonomous transaction pragma it will NOT work!

    -amar

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