Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal oracle password
Hi Chris,
> I have a couple of questions that I have wondered about for a while.
When I
> install, I have a user auto created called internal that I can use to
do
> anything in the database with (startup, shutdown, etc). How can I
change
> the password for internal?
***
INTERNAL - pseudouser, synonym for user SYS.
If you want to change INTERNAL password - simply change SYS password.
> Also, before I do that I want to give my
system
> user (or another user for that matter) full DBA privleges so he can
startup
> and shutdown the database. When I try to shutdown the database now as
> system, I get ORA-01031: insufficient privileges. I have tried giving
the
> roll DBA, SYSDBA and neither seem to solve the problem. I am sure
this is
> probably an easy thing to do.
You must grant role SYSDBA to your user and when connect specify 'AS SYSDBA'
connect internal/<PWD>
grant SYSDBA to <user>;
connect <user>/<user pwd> AS SYSDBA
shutdown
> Also, what needs to happen so I could log like connect / as
sysdba; I
> currently cannot do this and am wondering what I need to do.
>
What you interested - connection without the indication of the
username/password or connection AS SYSDBA?
--
Regards,
Oleg Tsibulnyak
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 07:35:47 CDT
![]() |
![]() |