Advanced Database Properties

image_pdfimage_print

After the selection of a database in Modeler, a user with the corresponding rights can define the following settings in the section „Advanced“ of the tab „Database Properties“:

1. Visibility of Elements with User Access Right N

 

2. Default Access Right to the Database

 

3. Initial Access Right to this Database for New Groups

 

4. Database Default Language

 

 

All these settings are entries of the #_CONFIGURATION cube of a database.

1. Visibility of Elements with User Access Right N

This field reads/writes the content of the cell [HideElements,~] in the #_CONFIGURATION cube of the database.

The #_CONFIGURATION cube is a system cube, therefore value changes are controlled by the rigths object ‘system operations’ (not by ‘cell data’ right).

If a user wants to change the entry, he needs rights to ‘see’ cell, i.e. at least ‘R’ for ‘database’, ‘cube’, ‘dimension’ and ‘dimension element’ rights objects.
Additionally he needs at least ‘W’ for database access and at least ‘W’ for ‘system operations’ rigths object.

The possible values are:

  • Hide Elements (writes ‘Y’ into the cell [HideElements,~])
  • Show Elements (writes ‘N’ into the cell [HideElements,~])

If HideElements is set to ‘Y’, elements where access is explicitly denied for a given group (that is, ‘N’ is defined for this element or a parent element in cube #_GROUP_DIMENSION_DATA_<dimension name>) will be hidden in a newly created view, or any listing of this dimension. The DefaultRight setting, however, does not influence the visibility of elements themselves.

 

2. Default Access Right to the Database

Preliminary note:

At first the access to database X is defined in #_GROUP_DATABASE_DATA cube for database X. E.g. if a user wants to read/write/delete a value in database X he must be a member of a group which has R/W/D in #_GROUP_DATABASE_DATA cube for database X.

If the corresponding cell in #_GROUP_DATABASE_DATA cube is empty, then for database access the value „Default Access Right to the Database“ (2) is used.

Default Access Right to the Database“ is the content of cell [DefaultRight, ~] in the #_CONFIGURATION cube of the database. This cell cannot be empty. This cell receives its value from the entry “default-db-right” in the palo.ini or, if it is not defined in palo.ini , the default value ‘D’ is set in this cell. In database migration cases from old versions, this cell will be filled with ‘D’ by Olap server during startup.

The item „Default Access Right to the Database“ (2) in the screenshot above will read/change this value. For changing the value you need the same rights as described above for 1. 

The possible values are:

  • None (N): No type of access permitted.
  • Read (R): Access rights for reading.
  • Write (W): Access rights for writing.
  • Delete (D) Access rights for deletion.

 

3. Initial Access Right to this Database for New Groups

This item reads/writes/deletes the content of cell [InitialAccessRight, ~] in the #_CONFIGURATION cube of the database.

When new user groups are created, this cell entry is used to define which access those new groups will get to the given database after creation.

For changing the value you need the same rights as described above for 1, with one exception: the [InitialAccessRight, ~] cell can be empty.
So you need for value change at least ‘W’ for database access and at least ‘W’ for ‘system operations’ rigths object.
For value deletion you need ‘D’ for database access and ‘D’ for ‘system operations’ rigths object.

The possible values are:

  • “Empty”
  • None (N): No type of access permitted.
  • Read (R): Access rights for reading.
  • Write (W): Access rights for writing.
  • Delete (D): Access rights for deletion.

 

4. Database Default Language

This item reads/writes/deletes the content of cell [DefaultLanguage, ~] in the #_CONFIGURATION cube of the database. All languages that are generally supported by Jedox Web can be chosen. More about the database language you will find in the article „Internationalization of Databases“.

For changing the value you need the same rights as described above for 1, with one exception: the [DefaultLanguage, ~] cell can be empty.
So you need for value change at least ‘W’ for database access and at least ‘W’ for ‘system operations’ rigths object.
For value deletion you need ‘D’ for database access and ‘D’ for ‘system operations’ rigths object.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...