About Security

You can enable users to access the dimensional objects in a schema at several levels:

Analytic Workspace
Individual Cubes and Dimensions
Selections of the Data

Access to an Analytic Workspace

You can grant privileges to users and roles on a particular analytic workspace. The privileges are SELECT, UPDATE, ALTER, INSERT, and DELETE. Privileges on the analytic workspace do not give privileges on any cubes or dimensions. You must grant those privileges separately.

For instructions on granting access to an analytic workspace, refer to Setting Object Security .

Access to Individual Cubes and Dimensions

You can grant different types of privileges to users and roles on individual cubes and dimensions. For example, you might want to allow a particular user to see only one of several cubes in an analytic workspace. For cubes, the privileges are SELECT, UPDATE, and ALTER. Dimensions also have these privileges, plus INSERT and DELETE.

For instructions on granting access to particular objects, refer to Setting Object Security .

Access to Selections of the Data

You can grant users and roles access to slices of a cube by limiting access to particular members of the cube's dimensions. For example, you might restrict district sales managers to the data for just their own districts. You can assign SELECT, INSERT, UPDATE, and DELETE privileges on the selected dimension members.

For instructions on granting access to selections of data, refer to Creating Data Security Policies .