I was working on an incident this morning, my friend who is a part of the IT governance team cannot access her account. The application uses Sybase ASE as its database.
I asked for her login credentials. She gave me her ID, but she wasn't sure which instance she needed. I told her that was fine, I only needed to check 2 instances for her based on what she was trying to do.
I logged in to the database instances in question and did a sp_displaylogin for her ID. I saw that in one of the instances, her ID didn't exist, and it was locked in the other instance. I figured that she would want access to the instance she already had an account in.
Now that I know what instance to fix her login in, I ran a sp_locklogin to unlock her account.
sp_locklogin userID, 'unlock'
go
go
Easy resolution.
No comments:
Post a Comment