Oracle EM Express Security Page provides the ability to administrate the Users, Roles, and Profile requirements of an Oracle database.  This article covers the general layout of EM Express Security Page and its functional usage.

 

1. Logon the EM Express as an administrative user.   In this case we will use the URL:  https://10.30.15.63:5500/em.   This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default).  NOTE:  You may receive a certificate warning but select continue to site option.   Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.

2. From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.

3. The Security drop down you have the options: Users, Roles, and Profiles.

4. The Users option allows you to view all users of the database, add/drop users, modify the permissions of a user and perform any maintenance tasks to a user account.

5. The Roles option allows you to view all defined database roles, add/drop roles, add permissions to roles, and perform any maintenance tasks to existing roles.

6. The Profiles option allows you to view all defined profiles of the database, add/drop profiles, modify profile parameters and perform any additional profile administration required.

 

This article summarized the feature and use of the Security Page of Oracle 12c EM Express.

 

Larry Catt

OCP