Skip Headers
Previous
Previous
 
Next
Next

Perform Grant Action (Dimension)

Users must have privileges on the cube dimension and the analytic workspace before accessing the dimension members. To query the dimension and hierarchy views, users must have SELECT access on them.

Properties

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

Object Name: The name of the dimension.

Users: The users and groups to whom you can grant access privileges.

With Grant Option: Enables the selected user or group to grant access rights to others.

Grant All: Select this option to grant all privileges on the dimension. Because this option grants more privileges than the few listed in the Available Privileges field, you should grant it only to those who need full control.

Available Privileges: Lists the privileges that you can grant on the selected object. Select one or more privileges and move them between the Available and Selected fields.

Selected Privileges: Lists the privileges to be granted to the selected user or group.

Extend all dimension privileges to analytic workspace Name: Grants the necessary privileges on the analytic workspace for the user to exercise the dimension privileges.

Extend the SELECT privilege to the dimension and hierarchy views: Enables the user to query the data displayed in the dimension and hierarchy views.

SQL

Displays the SQL command generated by this dialog box.

Related Topics

"About the Security of Dimensional Data in Oracle Database"

"Setting Object Security"