View User tool: Account Locked tickbox not working

[jamo]

Hi All

I searched the forum and could not find any topics dealing with it. Since we upgraded the database to 11g, I've found that the psd developer tool for viewing/editing users does not appear to display the account locked tickbox correctly.

select ACCOUNT_STATUS from dba_users where username='JTHORPE' returns "LOCKED", but

right-click on the user in the objects window and select view or edit and the "Account Locked" tickbox is unticked.

Any ideas?

 

[Marco Kalter]

This works fine for me. Can you let me know your PL/SQL Developer version and your Oracle Server version?

 

[jamo]

Hi Marco

Thanks for the response, sorry to only get back now but I thought I'd be notified if there were any responses.

PL/SQL Developer version: 8.0.4.1514
Oracle Server: 11g Standard Edition 1

I've just noticed the problem again this morning and colleagues of mine experience the same thing. On further investigation, it seems that although ACCOUNT_STATUS in dba_users view is "LOCKED", the LOCK_DATE field is null. Does the application perhaps query the LOCK_DATE field rather than ACCOUNT_STATUS to see if the account is locked?

And, furthermore, how did I get a situation where the account is locked but LOCK_DATE is null? Any ideas?

 

[Marco Kalter]

Thanks, we'll check it out.