-
if password for system sys/internal is changed then how i can break that and give anather password
thanks in advance
sridhar
-
connect as some other user with the 'alter user' privilege
and issue :
alter user sys identified by new_password;
John Dorlon
www.ezsql.net
john@ezsql.net
-
password
thanks for reply but with this command any one can change my sys password na
so just i want to put a password which can not be break by any of the user
plz help me out
sridhar
-
No, that was a wrong reply. If you were to loose the system/sys password, untill 8i you can connect through the server manager and then isssue "alter user sys identified by password". Once after loging into server manager you have to connect internal. If you cannot succeed there, then you could use the orapwd to recreate your password file and start working inwards from there.
Hope this would help you.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
password
Dear Sambavan
Sir I am not clear
plz tell me bit of clearly
thanks for reply
sridhar
-
Hi Sridhar,
Sambhavan meant
You can change any password by connecting as user
Internal
from server manager for example
set ORACLE_SID=youroraclesid
svrmgrl
svrmgrl> connect internal
svrmgrl> alter user sys identified by newpassword;
If you are not able to change the password thru the above procedure you can use the following utility
orapwd
the filename of this utility changes from version to version.
This utiliy creates a password file which will be stored on your hard drive.The above utility can be executed from command prompt or from $ prompt if you are on unix
If you are not familiar with orapwd utility perform a search on this forum you will find tons of Info.You will find search option on the top right hand corner
If you still have any question keep posting
Regards,
Santosh
-
Hello,
I would strongly you to use orapwd.exe to change the internal passwod rather than using the alter statement
Harsh
Best Regards,
Harsh Shah
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|