Manage Data Access through Security Assignments

As a security administrator, you need to map data security assignments to users to enable data level access.

Use the Security Assignments tab on the Security page to search for the currently set up data security assignments. You may either search for all records or narrow your search to a specific security context, security value, or user. You can remove a security assignment that you had set up or add new security assignments to a user.

Topics:

• Create a Security Assignment
• Delete a Security Assignment
• Remove Users from a Security Assignment
• Manage Users for a Security Assignment
• Upload and Download Data Security Assignments

Create a Security Assignment

Use these instructions to create a security assignment in a specific security context.

Security contexts are categories that contain values that you can secure a user for. For example, you can define which users have access to which "ledgers" or "departments". In this example, "ledgers" and "departments" are security contexts. Within "ledgers", you can have "ledger A", ledger B", or "ledger C" as values. You first select "ledger", then select a value such as "ledger A", and then select the users to secure for "ledger A". The selected users can access "ledger A".

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Security under Service Administration.
   You see the Security page.
3. On the Security page, click the Security Assignments tab.
   You see all users who have been granted the security assignments in a specific security context.
4. Click New Assignment.
5. In New Security Assignment, under Select Security Assignments, select a security context, and then search for a security value or select from the displayed list.Move the selected security assignments to the column on the right.
6. Under Select Users, search for a user and select the user and move the user to the column on the right.
   Users are filtered based on the role associated with that context.
7. Click Add to Cart and then click View Cart.
8. In Security Assignments, click Apply Assignments.
   You can grant this security assignment to other users as required. Bulk assignments may take some time to process. See the Security Activity tab for details.

Delete a Security Assignment

Use these instructions to delete a security assignment. When you delete a security assignment, Oracle Fusion Analytics Warehouse removes all users associated with the security assignment.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Security under Service Administration.
   You see the Security page.
3. On the Security page, click the Security Assignments tab.
4. Select a security assignment from the displayed list of assignments or search for a security assignment and select it.
5. Click Delete Assignment.

Remove Users from a Security Assignment

You can revoke the security assignment granted to one or more users.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Security under Service Administration.
   You see the Security page.
3. On the Security page, click the Security Assignments tab.
4. Select a security assignment from the displayed list of assignments or search for a security assignment and select it.
5. In the security assignment details region, select the users from the displayed list of users or search for and select the users.
6. Click Remove User.
7. In Revoke User Assignment, click Revoke Assignment.

Manage Users for a Security Assignment

As a security administrator, you can manage users for existing data security assignments. In the Manage Users dialog, you can revoke users for an existing assignment or add new users for that assignment.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Security under Service Administration.
   You see the Security page.
3. On the Security page, click the Security Assignments tab.
4. Select a security assignment from the displayed list of assignments or search for a security assignment and select it.
5. In the security assignment details region, click Manage Users.
6. In Manage Users:
   1. Under Add User, search for a user and select the user.
   2. Under User, click the Delete icon to revoke the user from the assignment.
7. Click Save.