Set Dimension Object Security dialog box

Use this dialog to grant or revoke privileges on dimensions.

Schema

The owner of the dimension.

Dimension Name

The dimension whose privileges are being set. Select a dimension from the drop-down list.

User or Role

The user or role whose privileges on the dimension will be changed. Select one from the drop-down list.

With Grant Option

Enables the user or role to grant the selected privileges to another user or role.

Available Privileges

The list of available privileges. Use the shuttle keys to move privileges from the Available list to the Selected list.

• SELECT: Query the object
• INSERT: Create new dimension members
• UPDATE: Change the data values of dimensions and cubes
• DELETE: Delete dimension members
• ALTER: Change the object definition

Selected Privileges

The privileges that will be granted to the user or role. Use the shuttle keys to remove any privileges that you want to revoke.

SQL Commands

Displays the SQL commands that are generated by your choices.

Related Topics

About Security

Granting and Revoking Object Security

Copyright © 2003, 2007, Oracle. All rights reserved.