Skip to main content
Database Administrators

Return to Question

added 50 characters in body
Source Link
jrdba
jrdba
  • 55
  • 1
  • 15

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.

The procedure must comply with the rules I have specified below:

  • If a user's expiry_date value is EXPIRED (select username, account_status, lock_date, expiry_date from dba_users where account_status='EXPIRED';), it will lock this user.

  • If a user's expiry_date value is EXPIRED and if it is already lock state, it will not do anything.

  • Exclude internal schemas for this operation.

I searched it but I didn't find any clear solution for it.

How can I create this procedure?

Best regards,

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.

The procedure must comply with the rules I have specified below:

  • If a user's expiry_date value is EXPIRED (select username, account_status, lock_date, expiry_date from dba_users where account_status='EXPIRED';), it will lock this user.

  • If a user's expiry_date value is EXPIRED and if it is already lock state, it will not do anything.

I searched it but I didn't find any clear solution for it.

How can I create this procedure?

Best regards,

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.

The procedure must comply with the rules I have specified below:

  • If a user's expiry_date value is EXPIRED (select username, account_status, lock_date, expiry_date from dba_users where account_status='EXPIRED';), it will lock this user.

  • If a user's expiry_date value is EXPIRED and if it is already lock state, it will not do anything.

  • Exclude internal schemas for this operation.

I searched it but I didn't find any clear solution for it.

How can I create this procedure?

Best regards,

Source Link
jrdba
jrdba
  • 55
  • 1
  • 15

Oracle 11g - Database Job About User Lock

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.

The procedure must comply with the rules I have specified below:

  • If a user's expiry_date value is EXPIRED (select username, account_status, lock_date, expiry_date from dba_users where account_status='EXPIRED';), it will lock this user.

  • If a user's expiry_date value is EXPIRED and if it is already lock state, it will not do anything.

I searched it but I didn't find any clear solution for it.

How can I create this procedure?

Best regards,