Skip Headers
Previous
Previous
 
Next
Next

Perform Revoke Action (Cube)

To access the data in a cube, users must have privileges on both the cube and the analytic workspace. To query the data, users must have SELECT access on the cube view.

Properties

Schema: The name of the schema where the cube is stored.

Object Name: The name of the cube.

Users: The users and groups that have access privileges on the cube. After you select a user or group, the current privileges appear in Granted Privileges.

Revoke All: Select this option to revoke all privileges on the cube.

Revoked Privileges: The privileges revoked from the selected user or group.

Granted Privileges: The privileges granted to the user or group. Select one or more privileges and move them between Granted Privileges and Revoked Privileges.

Extend all cube privileges to analytic workspace Name: Grants any remaining privileges on the analytic workspace.

Extend the SELECT privilege to the cube view: Enables the user to query the data displayed in the cube view.

SQL

Displays the SQL command generated by this dialog box.

Related Topics

"About the Security of Dimensional Data in Oracle Database"

"Setting Object Security"