Oracle^® Business Intelligence Server Administration Guide > Oracle BI Administration Tool Basics >

Setting Permissions for Repository Objects

You can assign user and group permissions to connection pools in the Physical layer and to Presentation layer objects. Additionally, you use Security Manager to set up privileges and permissions. For more information about managing security, refer to Oracle BI Security Manager.

The Permissions dialog box displays all currently defined users and groups. to see all users and groups, select the check box named Show all users/groups. For each user and group, you can allow or disallow access privileges for an object by clicking in the check box to toggle among the following options:

• A check mark indicates that a permission is granted.
• An X indicates that a permission is denied.
• An empty check box indicates that a permission has not been modified.

You can access the Permissions dialog box from the following dialog boxes:

• Connection Pool—General tab
• Presentation Catalog Folder—General tab

  NOTE:  The term Presentation Catalog in the Administration Tool refers to subject areas.

• Presentation Table—General tab
• Presentation Column—General tab

To add or edit permissions from a connection pool

1. Open a repository in the Administration Tool, expand a physical database, and double-click a connection pool.
2. In the Connection Pool dialog box, click Permissions.
3. In the Permissions dialog box, select the appropriate options for each user and group that you want to modify.
4. Click OK.

Sorting Columns in the Permissions Dialog box

There are six ways that you can sort the types and User/Group names. In the Permissions dialog box, there are three columns. The first column (sort on this column) has no heading and contains an icon that represents the type of user or group of users. The second column (sort on this column) contains the name of the User/Group object, and the third column (cannot sort on this column) contains the Read check box. To change the sort, click the heading of the first or second column.

There are three ways to sort by type and two ways to sort the list of user and group names. This results in a total of six possible sort results (3 x 2 = 6). The following list shows the sort results available by clicking the type column:

• Everyone, Groups, Users (ascending by name of type)
• Users, Groups, Everyone (descending by name of type)
• Type column is in no particular order (Type value is ignored as all names in User/Group column are sorted in ascending order by value in User/Group column)

The following list shows the sort results available by clicking the User/Group column:

• Ascending within the type
• Descending within the type

Examples of Sorting Columns in the Permissions Dialog Box

If you want to sort all rows first by type in ascending order and then, within type, sort the User/Group names in ascending order, use the following steps in the sequence shown:

1. Click the blank heading above the type column until the Everyone type appears at the top.

   The type column is in ascending order.

2. If the User/Group name column is in descending order within each type, click the User/Group heading once.

   The list is sorted by type in ascending order and then within type, by User/Group names in ascending order.

3. To change the sort by type to descending order, leaving the User/Group names in ascending order, click the type (blank) heading once.
4. To change the sort to ignore the type column and sort only on the names in the User/Group column in ascending order, click the type heading once more.
5. To continue ignoring the type column and change the sort for the names in the User/Group column to be in descending order, click the User/Group heading.