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.

Auditing

3 posts in replicator Last posting was on 2007-02-02 14:01:37.0Z
Robin Posted on 2007-02-02 13:15:05.0Z
Sender: 5043.45c0e652.1804289383@sybase.com
From: Robin@RobinStClair.com
Newsgroups: sybase.public.ase.replicator
Subject: Auditing
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45c34769.79c9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Feb 2007 06:15:05 -0700
X-Trace: forums-1-dub 1170425705 10.22.241.41 (2 Feb 2007 06:15:05 -0700)
X-Original-Trace: 2 Feb 2007 06:15:05 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:166
Article PK: 103371

I am presently designing a system that will require more
that normal confidentiality and security. It is also a
requirement that an audit trail of actions by users be
maintained.

Has anybody any experience of the Audit features that are
available. Specifically are they adequate in the face of
administrative and legislative interest in the system.

Has anybody any experience of 'rolling their own' audit
system and have they any views on the pros and cons of going
this route. I am envisaging possibly using the replication
tools to create such an audit trail.

The system will also need to be encrypted and it could all
get a little 'sensitive'.

Any advice or 'war stories' would be appreciated.

Robin


Jason L. Froebe [TeamSybase] Posted on 2007-02-02 13:22:29.0Z
From: "Jason L. Froebe [TeamSybase]" <jason@froebe.net>
Organization: TeamSybase
User-Agent: Thunderbird 1.5.0.9 (X11/20070103)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: Auditing
References: <45c34769.79c9.1681692777@sybase.com>
In-Reply-To: <45c34769.79c9.1681692777@sybase.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: c-24-14-200-200.hsd1.il.comcast.net
X-Original-NNTP-Posting-Host: c-24-14-200-200.hsd1.il.comcast.net
Message-ID: <45c34925$1@forums-1-dub>
Date: 2 Feb 2007 06:22:29 -0700
X-Trace: forums-1-dub 1170426149 24.14.200.200 (2 Feb 2007 06:22:29 -0700)
X-Original-Trace: 2 Feb 2007 06:22:29 -0700, c-24-14-200-200.hsd1.il.comcast.net
Lines: 43
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:168
Article PK: 103374


Robin@RobinStClair.com wrote:
> I am presently designing a system that will require more
> that normal confidentiality and security. It is also a
> requirement that an audit trail of actions by users be
> maintained.
>
> Has anybody any experience of the Audit features that are
> available. Specifically are they adequate in the face of
> administrative and legislative interest in the system.
>
> Has anybody any experience of 'rolling their own' audit
> system and have they any views on the pros and cons of going
> this route. I am envisaging possibly using the replication
> tools to create such an audit trail.
>
> The system will also need to be encrypted and it could all
> get a little 'sensitive'.
>
> Any advice or 'war stories' would be appreciated.
>
> Robin

Hi Robin,

This can be done easily.. you could either set up replication on the
audit tables to transfer the audit records to a 'repository' or you can
do this with a custom script.

Along with the audit records, I would pull some of the MDA table
information into the repository as they compliment each other with
regards to auditing

--
Jason L. Froebe

Help find a cure for breast cancer! Net proceeds benefit the Susan G.
Komen Breast Cancer Foundation and the National Philanthropic Trust.
Help by donating at http://www.the3day.org/chicago07/jfroebe - I'm
walking 60 miles in 3 days in August 2007. (The day I return from
TechWave is the first day of the Walk)

WebBlog http://jfroebe.livejournal.com
Tech log http://www.froebe.net/blog