Assinging 'Select' previliges.

[amar]

Even with autonomous transaction pragma it will NOT work!

-amar

[Zaggy]

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?