Managing access to the Database Administration Console

As an administrator, you can customize the operator role to manage access to the Database Administration Console (Database Administration) of OpenEdge Management or OpenEdge Explorer. You can set the following permissions:

Disallow Read Access — If this option is selected, Database Administration is disabled for the operator

Allow Create Connections — If this option is selected, Database Administration is enabled for the operator. The operator can create a new database connection. The operator can also create a copy of or delete an existing database connection.

Allow Edit Connections — If this option is selected, Database Administration is enabled for the operator. The operator can edit an existing database connection.

Without any Database Administration Console permissions assigned, by default, the operator can use existing database connections. For more information on creating, editing, and using database connections, see OpenEdge Management and Explorer: Configuring Multi-tenancy and OpenEdge Management and Explorer: Managing Table Partitioning in Databases.

The assigned role permissions are saved as JSON values in the fathomRealm.policy file that is available in the <OpenEdgeManagement-install-dir>\etc folder. The following sample shows the default Database Administration Console permission for the operator role:

{
"roles" : [
{
// Administrator roles
},
{
"name" : "PSCOper"
"grants" : [ {
// Other operator roles
},
{
"object" : "dac.*",
"actions" : "read"
}
]
},
{
// Trend user roles
}
]
}

The following table shows the assigned JSON values in the fathomRealm.policy file for the permissions to the Database Administration Console:

Table 4. Permissions to the Database Administration Console
Permission	JSON value
Disallow Read Access	"actions" : ""
Allow Create Connections	"actions" : "create"
Allow Edit Connections	"actions" : "write,read"

To manage access to the Database Administration Console:

1. In the Options page, click Customize Operator Role. The Operator Role Customization page appears.

2. In the Database operations area, select the operator permissions under Database Administration Console.

Note: If you are moving from an older version of OpenEdge Management or OpenEdge Explorer to version 11.6 and you still want to continue using the fathomRealm.policy file from the older version, you must add information related to the Database Administration Console permissions in the file.