Date:         Mon, 9 Oct 1995 13:02:26 -0700
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         David Thornewill von Essen
Subject:      Re: User Survalance
In-Reply-To:  <199510091541.AA11112@gateway.timken.com> from "DANIEL J. YEAGER"
              at Oct 9, 95 11:10:30 am

You indeed could use RPORC and UPROC to control access to parts
of tables that need secutrity.  You can also use them to maintain an
audit log as well.  In fact, I wouldn't write an audit log to the file
system, but rather to a table in the database using a shared DB.  That
will let you query for changes etc.

If you're interested I could send you an example schema.

Regards,
David TvE

According to DANIEL J. YEAGER:
>
>      I have a rather large application that users from two separate
> geographic areas use.  The two areas are competing for the same type
> of work from a series of customers.  I have run into a situation where
> one area is deleting the other areas records and creating their own
> so that the system directs the work their way.  I have put a stop to
> this by checking the user security in the procedures that are used and
> either allow or disallow the action.
>      My situation is that one of the users in the area in question is
> capable of creating procedures that he can give to his users that will
> over ride my changes.  Our environment is VM with Nomad 6.03 and SQL/DS.
>      My question is --- is there a way to have the Schema write info to
> a data audit table if a delete is performed?  I've looked at the Rule
> and uproc statements but these appear to either allow or disallow a
> function, not track a function.  Audit appears to write to a dataset
> and not to a table.  Our users don't access any disks as read/write so
> the only location I could write the audit file to is their 191 disk.
> This would not allow me to view the audit file.  Any ideas?
>                                             Thanks, Daniel J. Yeager
>                                                     Yeagerd@Timken.com
>


--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
! David Thornewill von Essen                MRPII Project Coordinator !
! Motorola LATG Operations                     Maildrop: AZ34 / EL557 !
! Tempe, AZ-85284                                 fax: (602) 413-5566 !
! email: ttg242@email.sps.mot.com                 tel: (602) 413-6051 !
+---------------------------------------------------------------------+
!      'At times we must engage an act of faith that key              !
!       things are doable that are not provable' -- Bob Galvin        !
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
back to index