Login  Register

change sys user password

classic Classic list List threaded Threaded
5 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

change sys user password

Arsala
5 posts
Sir

I have problem how to change password of sys user
I used like ( alter user sys identified by XXXX;  

but when I connect like

sys as sysdba     --when I press deuble enter it does not required passward without password we can enter to database.

please guide me the sys user should enter valid password without password it can not enter to db.
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: change sys user password

ErmanArslansOracleBlog
Administrator
5731 posts
It is not sqlplus as sysdba

It should be sqlplus / as sysdba

--there should be a "/" there.
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: change sys user password

Arsala
5 posts

Sir

I want to enter to Database
as sys user but it must take password from me

example

connect sys as sysdba while we double press enter it not take password from me

so I must give valid password of sys user without it we should not enter to DB.
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: change sys user password

ErmanArslansOracleBlog
Administrator
5731 posts
then , use "sqlplus sys as sysdba"
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: change sys user password

Arsala
5 posts


OK THANKS