Re: password on internal?

From: <vermaat_at_gemini.tfdl.agro.nl>
Date: 1996/04/16
Message-ID: <1996Apr16.062755.443_at_ns2>#1/1


In article <316ED6CE.B2E_at_sunvm2.corp.mot.com>, Louis Lang <root_at_sunvm2.corp.mot.com> writes:
>Greetings from a new Oracle DBA...
>
>We (another newbie Oracle DBA and I) would like to change (or establish)
>a password on the 'internal' user. Is this possible? ALTER USER
>doesn't do it (user does not exist). Any information would be greatly
>appreciated. Thanks.

You simply can't. Connecting as "internal" in SQL*DBA means the same as connecting as SYS in SQL*Plus. The only way you can keep a user from connecting as "internal" is denying him the rights identifier ORA_DBA (that is on the VMS platform; don't know about Unix).



| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |
|                           Flagellant in Dreamland                            |
********************************************************************************
Received on Tue Apr 16 1996 - 00:00:00 CEST

Original text of this message