SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find table name(s) in a dynamic query

217886Jun 3 2004 — edited Jun 3 2004

In one of our (9iAS PORTAL)applications, any user can able to run their query statment and get output. All queries will be executed as dynamic SQL thru' a common shema/user who has 'SELECT' privilege on all tables but all users don't have this privilege on all tables. Now, before executing any query I need to find out what are the table name(s) used in this query to check the privilege for the respective user. How do I extract all table names being used in a dynamic query?.

Thanks
-Krishnamurthy

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2004

Added on Jun 3 2004

5 comments

518 views