how can i do that?

well, if your back end database is SQLserver, you could put triggers on all
your tables to track the changes.

You could also within the ASP code write a function to insert into a table
the sql string you execute and store it along with the current logged in
user.

Just a couple ideas
"Sandy" <webdev.@127.0.0.1> wrote:
>
>i have to check the access of all tables, i have to mark down who make the
>access and what have been done, how can i do that?

Hi Sandy,

When you say tracking the access, which access do you mean?

If you mean changes to actual tables, then what you are trying to do basically
is called database auditing. The purpose of this is to track all the changes
to a database (a simple definition).

Is this what you are trying do? Please let me know.

Harish Mohanbabu

"Sandy" <webdev.@127.0.0.1> wrote:
>
>Thank you for your response, but how can I create a trigger to get the user
>name as a variable?
>
>
>"Q*bert" <luke_Davis_76@hotmail.com> wrote:
>>
>>well, if your back end database is SQLserver, you could put triggers on
>all
>>your tables to track the changes.
>>
>>You could also within the ASP code write a function to insert into a table
>>the sql string you execute and store it along with the current logged in
>>user.
>>
>>Just a couple ideas
>>"Sandy" <webdev.@127.0.0.1> wrote:
>>>
>>>i have to check the access of all tables, i have to mark down who make
>the
>>>access and what have been done, how can i do that?
>>
>

Harish,

Thank you for your response.
I want to track all the access to the tables, that is can track someone
select, update, delete, insert into the tables.

"Harish Mohanbabu" <HarishM@MailCity.Com> wrote:
>
>Hi Sandy,
>
>When you say tracking the access, which access do you mean?
>
>If you mean changes to actual tables, then what you are trying to do basically
>is called database auditing. The purpose of this is to track all the changes
>to a database (a simple definition).
>
>Is this what you are trying do? Please let me know.
>
>Harish Mohanbabu
>
>
>
>"Sandy" <webdev.@127.0.0.1> wrote:
>>
>>Thank you for your response, but how can I create a trigger to get the
user
>>name as a variable?
>>
>>
>>"Q*bert" <luke_Davis_76@hotmail.com> wrote:
>>>
>>>well, if your back end database is SQLserver, you could put triggers
on
>>all
>>>your tables to track the changes.
>>>
>>>You could also within the ASP code write a function to insert into a table
>>>the sql string you execute and store it along with the current logged
in
>>>user.
>>>
>>>Just a couple ideas
>>>"Sandy" <webdev.@127.0.0.1> wrote:
>>>>
>>>>i have to check the access of all tables, i have to mark down who make
>>the
>>>>access and what have been done, how can i do that?
>>>
>>
>

Almost forgot to attach this link -

http://www.developersdex.com/gurus/articles/49.asp

Regards,

Harish Mohanbabu

"Harish Mohanbabu" <HarishM@MailCity.Com> wrote:
>
>Hi Sandy,
>
>Did you had a look at the URL that I posted earlier? That should give you
>a start.
>
>Cheers,
>
>Harish Mohanbabu
>
><webdev.@127.0.0.1> wrote:
>>
>>Harish,
>>
>> Thank you for your response.
>> I want to track all the access to the tables, that is can track someone
>>select, update, delete, insert into the tables.
>>
>>
>>"Harish Mohanbabu" <HarishM@MailCity.Com> wrote:
>>>
>>>Hi Sandy,
>>>
>>>When you say tracking the access, which access do you mean?
>>>
>>>If you mean changes to actual tables, then what you are trying to do
basically
>>>is called database auditing. The purpose of this is to track all the changes
>>>to a database (a simple definition).
>>>
>>>Is this what you are trying do? Please let me know.
>>>
>>>Harish Mohanbabu
>>>
>>>
>>>
>>>"Sandy" <webdev.@127.0.0.1> wrote:
>>>>
>>>>Thank you for your response, but how can I create a trigger to get the
>>user
>>>>name as a variable?
>>>>
>>>>
>>>>"Q*bert" <luke_Davis_76@hotmail.com> wrote:
>>>>>
>>>>>well, if your back end database is SQLserver, you could put triggers
>>on
>>>>all
>>>>>your tables to track the changes.
>>>>>
>>>>>You could also within the ASP code write a function to insert into a
>table
>>>>>the sql string you execute and store it along with the current logged
>>in
>>>>>user.
>>>>>
>>>>>Just a couple ideas
>>>>>"Sandy" <webdev.@127.0.0.1> wrote:
>>>>>>
>>>>>>i have to check the access of all tables, i have to mark down who make
>>>>the
>>>>>>access and what have been done, how can i do that?
>>>>>
>>>>
>>>
>>
>