From the OpenEdge Command Center console, you can view details of schema, users, and roles of a running database, as follows:

  1. In the OpenEdge Command Center console, click OpenEdge Databases.
    The OpenEdge Databases page appears.
  2. Select the checkbox next to the running OpenEdge database for which you want to view the details. The <database_name> pane appears at the bottom of the page, displaying three disabled tabs: Schema, Users, and Roles.
  3. Log into the database by clicking Login. The Database Authentication dialog box appears.
    1. In the Database User ID field, type the username.
    2. In the Database Password field, type the password.
    3. Click Authenticate.
      The Schema, Users, and Roles tabs are enabled.
  4. Click each of the Schema, Users, or Roles tab to view the corresponding details of the database.
    1. To view the details about database schema and their tables and columns, click the Schema tab. The following sections appear:
      • Tables: Lists the tables within the database.
      • Columns: Lists the columns that are associated with the table.
      • Details: Lists the column details, such as field, datatype, display format, and default value.

      You can quickly search for tables and columns by clicking the search icon next to the corresponding section title. You can get the latest data from the OpenEdge database by clicking Refresh.

    2. To view the users who have access to the database, and their usernames and associated roles, click the Users tab. The following sections appear:
      • Users: Lists all the users within the database.
      • Details: Lists the user details, such as username and roles assigned to the user.

      You can quickly search for users by clicking the search icon next to the Users section title. You can get the latest data from the OpenEdge database by clicking Refresh.

    3. To view details about various system-defined roles, click the Roles tab. The following sections appear:
      • Roles: Lists the system-defined roles.
      • Details: Lists the role details, such as created by, type, and description.

      You can quickly search for roles by clicking the search icon next to the Roles section title. You can get the latest data from the OpenEdge database by clicking Refresh.