May 19, 2004 at 8:08 am
I have an application accessing various tables in a SQL Server database.
I want to have a list of all those table which the application has accessed for select , Insert and update operation.
Currently i am using SQL Profiler to trap all the queries and searching for table names in TextData column.
Is there any way to get the list of tables which the application is accessing.
May 19, 2004 at 9:38 am
It is a good start with trace, by doing trace you find out what your application use as login, based on the login you could go into the actuall database, select the login and find out if it has access to any database roles, if it doesn't belong to any roles, you could check on permission and it will list permission for table, view, stored procedures that the login has access to and what type of access it has weather it is select, update, delete, or insert.
mom
May 20, 2004 at 3:04 pm
As an aside, this is a good reason why your applicate shouldn't access tables directly. In this case, you would only have to change the procs (which you would still have to find), and not change the application code at all.
Signature is NULL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply