Re: ORA-01031: insufficient privileges

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Feb 2007 13:28:46 -0800
Message-ID: <1172266125.739304@bubbleator.drizzle.com>

lazyboy_2k_at_yahoo.com wrote:
> Hi All,
>

>> What UNIX account owns the installation?

>
> It should be sysdba:oracle, but it's changed now & pls see the below
> for explanation.
>

>> Is it the same as when you type whoami?

>
> No, it's not the same, but does it matter?
>
> # su - sysdba

Second time:

SYSDBA is a role inside the database ... it is not a user either in the operating system or in the database.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Feb 23 2007 - 15:28:46 CST