INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to reset SYSADM password?

How to reset SYSADM password?

(OP)
I know the sysadm password can not be reset. But is there any alternative way to dig out the lost SYSADM password?
One of our customer has lost his SYSADM password.
Please help...

RE: How to reset SYSADM password?

Sorry...no way to find it out...the only possibility is to unload the database, with an other user, table by table and load it again in a new database!

RE: How to reset SYSADM password?

(OP)
Thanks for your valuable information, I am trying that only. But I don't know any user in database having admin priviledges. I tried table by table unload using SYSSQL user, but giving me an error - Error: 04409 UNL CUS Unload of system table not allowed.



RE: How to reset SYSADM password?

thats right...you can only unload the non-system-tables. but you donĀ“t have to unload them because when you create a new database to load the unloaded data, all the systables are exists in a empty sqlbase database! Only the user tables, I mean all the table which are created additional to the database, have to be unloaded!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close