Re: Cannot login as SYSTEM/SYSDBA

Simple syntax error. It should be "grant sysdba to system".

HTH. Pete

Vadim Grepan wrote:

> Hello Kenny!
> >Check v$pwfile_user. By default SYSTEM does not have SYSDBA privileges.
>
> Yes:
> ---cut-------------------------------------------------------
> SVRMGR> select * from v$pwfile_users;
> USERNAME SYSDB SYSOP
> ------------------------------ ----- -----
> INTERNAL TRUE TRUE
> SYS TRUE TRUE
> 2 rows selected.
> ---cut-------------------------------------------------------
>
> And what should i do to grant SYSDBA to anyone, e.g. SYSTEM?
> I tried login as oracle and startup svrmgrl,but It fails.
>
> ---cut-------------------------------------------------------
> SVRMGR> grant sysdba on system;
> grant sysdba on system
> *
> ORA-00990: missing or invalid privilege
> ---cut-------------------------------------------------------

--

Regards

Pete

Received on Mon Jun 28 1999 - 10:58:46 CDT