From: "Michael L. Davis" on
Hello Friends,

From a birdie.

- Michael

At 02:58 PM 10/1/2007 -0400, a birdie wrote:

>You do not need to disable repository auditing when performing a backup.
>You only need to disable auditing before attempting to perform a
>restore. See the last bullet item on this page:
>
>http://support.sas.com/onlinedoc/913/getDoc/en/bisag.hlp/a003143750.htm
>
>
>-----Original Message-----
>Date: Thu, 27 Sep 2007 11:03:41 -0700
>From: afedakendragon <afedaken(a)GMAIL.COM>
>Subject: SAS Administration questions - %omabakup, and security.
>
>I've been handed a SAS Business Intelligence 9.1.3 server. We've had
>it for a while, and it runs, but our organization has until recently
>not had a dedicated SAS support person. I'm now that dedicated
>person. Of course this is my first time so bear with me if these are
>silly questions.
>
>I've been tasked by the powers that be to backup the metadata.
>According to the docs I've read, %omabakup would seem to be the best
>method to accomplish this. It's easily scheduled, can be run in a
>separate process, and handles locking and unlocking the metadata
>automagically. But it requires that we turn off the auditing for
>every repository that we backup. Turning off the auditing (And
>turning it back on) appear to be Management-console-only events, which
>would prevent me from scripting and automating the process. Since I
>do want to automate the backups, this leads to the following
>questions:
>
>- Is it possible to run %omabakup with the auditing still enabled?
>(I suspect the answer is no.)
>- Alternately, is there a way to turn on/off the auditing without the
>use of Management Console?
>
>We don't yet have a SAS security expert on staff. (I suspect this
>will be another hat I'll be wearing.) I'm learning a lot about how
>SAS security works, and whiel not simple by any means it's not
>terribly different from file permissions I've worked with as an
>admin. In my past life as a Windows/Unix admin, there were myriad
>tools I could use to analyze a given drive and output all it's current
>security settings. There were also tools that could when provided a
>target directory and user, could output the effective permissions that
>would result.
>
>- Are there any similar security aduit tools available within the
>default SAS macros?
>- Are there any similar third-party security audit tools available?
>
>Thanks in advance for any help you can offer.

Michael L. Davis
Ambler PA
E-Mail: michael.davis(a)alumni.duke.edu