Setting Up Permissions for LROs

Users who add, edit, and delete LROs through client interfaces must have the appropriate permissions in the active database. If the object is a linked partition, the user must also have the required permissions in the database containing the linked partition. Table 29 lists the permissions required for several different tasks.

Table 29. Permissions Required for LRO Tasks

Task

Permission

Add a linked object to a database

Read-write

View an existing linked object

Read

Edit an existing linked object

Read-write

Delete a linked object

Read-write

Export the LRO catalog to a file

Read

Import the LROs from the LRO-catalog file

Read-write

To prevent users from linking files to data cells without changing user access to other data in a database, you can set the maximum file size for linked files to 1. Users can then create cell notes, link to a URL, or view linked partitions but can attach only files smaller than 1 KB.

  To set the maximum LRO file size for an application, see “Limiting LRO File Sizes” in the Oracle Essbase Administration Services Online Help.