Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYS-SYSDBA

Re: SYS-SYSDBA

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 12 Mar 1999 11:54:16 -0000
Message-ID: <921239838.12324.0.nnrp-07.c2de6f3d@news.demon.co.uk>


sysdba and syoper ar privileges, not users as sys and system are. i.e. sysdba and sysoper can be granted to a user and then that user can connect 'as sysdba' or 'as sysoper' to enable those priviliges for the duration of their session.

see page 1-9 of db admin guide.

neil.

Roberto wrote in message <36E8F3EC.6EA858DE_at_sunul-1.ita.es>...
>Hi i'm new in Oracle, i've installed the Oracle8 Enterprise server, and
>I connect it with SYS and default password and connect as normal, all
>work well, but when i connect it as SYS , default password and connect
>as SYSDBA or SYSOPER, it say me 0RA-01017:invalid
>username/password;logon denied.
>
>Why is it? How can i connect as SYSDBA?
>
>many thakns
>
Received on Fri Mar 12 1999 - 05:54:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US