Account Management

The following new EM CLI verbs have either been added or modified for target database account management:

Note:

For more information about these verbs, including examples, see the Verb Reference chapter in the Oracle Enterprise Manager Command Line Interface.

• get_db_profile

  Displays the database profile details such as profile, resource name, resource type, and limits for a specific search criteria. The following example displays details about the profile with the name DEFAULT:

  emcli get_db_profile 
        -target_name=myDB 
        -profile= DEFAULT 
        -connect_as="DBNamedCreds:SYS_myDB"
  

• get_db_account

  Displays database account details such as username, profile, account status, and authentication type for a specific search criteria. The following example displays the details of the user Admin1:

  emcli get_db_account 
        -target_name=myDB 
        -user_name=Admin1  
        -connect_as"DBNamedCreds:SYS_myDB"
  

• update_db_account_status

  Updates the database account status to LOCKED, OPEN, EXPIRED,or LOCKED & EXPIRED. The following example locks the account:

  emcli update_db_account_status   
        -target_name=myDB   
        -user_name=Admin1 
        -action=LOCK  
        -connect_as="DBNamedCreds:SYS_myDB"
  

• update_db_password

  Updates the target database password change in the Enterprise Manager Credential sub-system and can change the password on the target database as well. This verb also propagates the collection or monitoring credentials to Enterprise Manager Management Agents.

  The EM CLI verb update_db_password can now change passwords for all users, including SYS/SYSDBA users. The verb can change passwords for the database target and all Enterprise Manager credentials. It syncs the password file across RAC and Dataguard instances. It accepts database named credentials to logon to database targets if it is used for changing other users' passwords. The following example updates the database password:

  emcli update_db_password
        -target_name=myDB
        -user_name=Admin1