Query on SQLPLUS

[Former Member]

Hi,

I want to get some information on SQLPLUS from the dba users, in which table i can find these information:

- Date from the last logon

- Date from last password change.

I already run desc dba_users and there is any field where i can find the required information.

Can you help me on this question.

Kind regards,

Nuno

[Former Member]

Hi Nuno,

Probably, you will need to activate the Oracle auditing to be able to get the information that you want.

More information about Oracle auditing refers to : http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/audit.htm#13360

Depending on your requirements I suggest you to use the profiles to configure password management in you database.

Best Regards,

Itamar Marioto

[fidel_vales]

Hi,

Eric is correct, that has nothing do do with SAP.

Keep in mind that in SAP there is "only" one database user, therefore your queries will have no sense in such environment.

Remember if you adquired oracle from SAP, the licence does not allow you to create new users.

[former_member204746]

try an Oracle forum on the Internet. this his not really a SAP question.