Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

sql auditing

4 posts in Replication Agent Last posting was on 2005-07-08 19:25:15.0Z
Hardev Dhindsa Posted on 2005-06-28 19:33:16.0Z
From: "Hardev Dhindsa" <hardevd@hotmail.com>
Newsgroups: sybase.public.rep-agent
Subject: sql auditing
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: h-68-167-75-109.nycmny83.covad.net
X-Original-NNTP-Posting-Host: h-68-167-75-109.nycmny83.covad.net
Message-ID: <42c1a5fc$1@forums-1-dub>
Date: 28 Jun 2005 12:33:16 -0700
X-Trace: forums-1-dub 1119987196 68.167.75.109 (28 Jun 2005 12:33:16 -0700)
X-Original-Trace: 28 Jun 2005 12:33:16 -0700, h-68-167-75-109.nycmny83.covad.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:807
Article PK: 862398

Can one use Replication Agent / LTL related technology for database auditing
purpose. For example, I would like to track all modifications to the
database.

Thanks.


"Mark A. Parsons" <iron_horse Posted on 2005-06-28 23:24:18.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola_compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: sql auditing
References: <42c1a5fc$1@forums-1-dub>
In-Reply-To: <42c1a5fc$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: s010600118028734a.ok.shawcable.net
X-Original-NNTP-Posting-Host: s010600118028734a.ok.shawcable.net
Message-ID: <42c1dc22$1@forums-1-dub>
Date: 28 Jun 2005 16:24:18 -0700
X-Trace: forums-1-dub 1120001058 24.71.130.61 (28 Jun 2005 16:24:18 -0700)
X-Original-Trace: 28 Jun 2005 16:24:18 -0700, s010600118028734a.ok.shawcable.net
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:808
Article PK: 862399

That sounds doable.

You'd most likely have to consider the use of function strings on your
DSI connection in order to save non-data info (eg, user, datetime stamp,
type of operation - insert/update/delete, actual deleted info, etc.).

Hardev Dhindsa wrote:

> Can one use Replication Agent / LTL related technology for database auditing
> purpose. For example, I would like to track all modifications to the
> database.
>
> Thanks.
>
>


Tommy Phillips Posted on 2005-06-29 20:54:52.0Z
From: Tommy Phillips <tommyp@acm.org>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: sql auditing
References: <42c1a5fc$1@forums-1-dub>
In-Reply-To: <42c1a5fc$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 209.78.214.253
X-Original-NNTP-Posting-Host: 209.78.214.253
Message-ID: <42c30a9c$1@forums-1-dub>
Date: 29 Jun 2005 13:54:52 -0700
X-Trace: forums-1-dub 1120078492 209.78.214.253 (29 Jun 2005 13:54:52 -0700)
X-Original-Trace: 29 Jun 2005 13:54:52 -0700, 209.78.214.253
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:809
Article PK: 862400


Hardev Dhindsa wrote:
> Can one use Replication Agent / LTL related technology for database auditing
> purpose. For example, I would like to track all modifications to the
> database.
>
> Thanks.
>
>

It's possible, but you should consider whether the regular ASE auditing
can give you enough information; it would be a lot easier to set up and
maintain.


sirish <sirish Posted on 2005-07-08 19:25:15.0Z
Message-ID: <42CED316.9000300@_REMOVE_ME_sybase.com>
From: sirish <sirish@_REMOVE_ME_sybase.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: sql auditing
References: <42c1a5fc$1@forums-1-dub> <42c30a9c$1@forums-1-dub>
In-Reply-To: <42c30a9c$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: sirish2k.sybase.com
X-Original-Trace: 8 Jul 2005 12:25:10 -0700, sirish2k.sybase.com
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Jul 2005 12:25:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Jul 2005 12:25:15 -0700
X-Trace: forums-1-dub 1120850715 10.22.108.75 (8 Jul 2005 12:25:15 -0700)
X-Original-Trace: 8 Jul 2005 12:25:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:810
Article PK: 862401

Please take a look at Sybase's Data Auditing Solution.

http://www.sybase.com/products/informationmanagement/sybasedataauditing
http://www.sybase.com/detail?id=1035134

The replication Agent/ LTL technology you refer to below are the
building blocks for this solution.

-sirish

Tommy Phillips wrote:
> Hardev Dhindsa wrote:
>
>> Can one use Replication Agent / LTL related technology for database
>> auditing purpose. For example, I would like to track all modifications
>> to the database.
>>
>> Thanks.
>>
> It's possible, but you should consider whether the regular ASE auditing
> can give you enough information; it would be a lot easier to set up and
> maintain.