Hello Geoff,
        Since you're memo did not provide any history, I'm making some
assumption here forgive for starting at the top:
        Though we're running UDB EEE, this should still apply.  If the
Oracle person can backup to *SM then he/she should be able to restore
without
modifying their operating system privileges.
        They should be able to backup their database to the filesystem and
restore from that backup (the is totally independent of *SM).   If not it's
either
an access privilege issue (ex. user doesn't have the right user group
privileges; user trying to write out to a filesystem they don't have access
to) and or setup issue
(ex. flags are not set...sorry don't know Oracle well enough to provide
examples, or USERID does not have backup/restore privileges within Oracle
therefore
the Senior Oracle DBA must set this up).
        Do you and/or the UNIX Admin know for certain whether or not this
"pseudo" individual" has backup their data to the local filesystem? If they
can perform a successful backup and restore to/from the filesystem but they
have not backup to *SM I would suggest checking the  *SM API configuration
you setup.

Regard,
Jacqueline

> -----Original Message-----
> From: Gill, Geoffrey L. [SMTP:GEOFFREY.L.GILL AT SAIC DOT COM]
> Sent: Wednesday, August 09, 2000 10:04 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Restoring files
>
> Someone please enlighten me. I have a Unix Administrator who has root
> access
> to all of his computers. He basically wants to give all of his users the
> right to restore files anytime they want. His reasoning is because he
> doesn't have access, here is his note to me:
>
> Note that we're talking about one pseudo-DBA on the Data Warehouse server.
> He doesn't have root access.  He does have "oracle" access (which I don't)
> which means he can only restore database related stuff (which I don't have
> responsibility for).
>
> He makes it sound like he can't do this but I get the feeling he just
> doesn't want to. Someone please help me understand why he couldn't do
> these
> restores because of his access. I am trying to limit the number of users
> that can do restores so this doesn't get out of hand.
>
> Thanks,
> > Geoff Gill
> > NT Systems Support Engineer
> > Computer Systems Group
> > E-Mail:   gillg AT saic DOT com
> > Phone:  (858) 826-4062
> > Pager:   (888) 997-9614
> >