is possible check whether oracle user able run particular query? check need performed admin account.
the reason have processes run using admin account. it's possible non-admins submit queries these processes, want able confirm during execution of process whether user able run query themselves, , if not, end execution.
the other piece process controlled java program, if there no way in oracle, perhaps there solution in java/jdbc?
java:1.5 oracle: 10.2+ tables involved part of admin schema, , access controlled via select/insert/update/delete table grants.
hope i've been clear enough
you try undocumented oracle package, dbms_sys_sql, has parse() method takes user id parameter. here link info: http://www.pythian.com/blog/using-dbms_sys_sql-to-execute-statements-as-another-user/
Comments
Post a Comment