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