Re: administrative rights to Windows Server

On 23 May 2007 09:36:14 -0700, Anthony <akkha1234_at_gmail.com> wrote:

>I know that we need administrative rights to a window box during
>installation and configuration.
>After cutover to production, is it possible for the DBA to survive if
>administrative rights are revoked?
>What daily/often-run tasks will be affected?
>
>Thanks for any suggestion.
>
>PS (Our system admin has taken away admin rights from us, so far, we
>are able to identify 10 areas, but all of them have workaround/fixes
>of some sort).

Yes, it is possible, provided your local windows account is in the local ora_<sid>_dba group (sid being optional), or you have set up a password file and granted any Oracle account sysdba and/or sysoper privilege.

Obviously, this is described in the Windows specific documentation.

-- 
 
Sybrand Bakker
Senior Oracle DBA