How to find out the tables used in a sql select statement?

The best way is to implement it at DB level. Databases have very good security definitions. You can define that user X can access only specific tables.

Attempt to access other tables will cause exception. Just check which exception is thrown in this case and implement logic that deals with it.

The best way is to implement it at DB level. Databases have very good security definitions. You can define that user X can access only specific tables.

Attempt to access other tables will cause exception. Just check which exception is thrown in this case and implement logic that deals with it. Other way is to parse SQL statement and retrieve DB table names prior to executing the statement.

Take a look on following discussion.

I was looking for sql parser, thanks – changed Dec 13 '11 at 17:10 you r welcome. Enjoy. – AlexR Dec 13 '11 at 17:44.

Try and parse SQL statement and retrieve DB table names prior to executing the statement.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.