Re: Locking Users

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 15 Aug 2002 23:16:46 -0400
Message-ID: <ulorl26trngfe4@corp.supernews.com>

Though in 9i I'm not sure what effect will locking SYS have? probably nothing. It does not prevent you from logging in as sysdba role (connect / as sysdba or connect sys as sysdba)

Anurag

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D5BC66B.558235FB_at_exesolutions.com...
> Michael Streeton wrote:
>
> > What restriction does locking a user have. Does it only stop them logging in
> > or will it also stop them running dbms_jobs etc. I have tried locking sys
> > and system and the db seems to have no problems at all. Is this okay?
> >
> > Many Thanks
> >
> > Mike
>
> When you lock SYS and SYSTEM exactly how do you log on and unlock them?
>
> Surely this is a joke.
>
> Daniel Morgan
>
Received on Thu Aug 15 2002 - 22:16:46 CDT