Defining the default permission value for a RAC or advanced MDAC cube in the object definition table

To set or update the default permission value of an MDAC or RAC cube (type 2 or 4), you can use, for example, this script: 
UPDATE [DEPM_MOD_CUBE] SET [DefaultPermissionValue] ='0' WHERE [ID]='DemoBA_#MDAC_Advanced'

Replace ‘DemoBA_#MDAC_Advanced’ with the ID of your MDAC or RAC cube.

If the default permission value is different to the global database setting for the default permission in multidimensional access cubes, specify one of these values:

  • 0 for the NONE permission
  • 1 for the READ permission
  • 2 for the WRITE permission
Related topics