typedef unsigned short | ESS_ACCESS_T | Security access level. Possible bit values are: ESS_PRIV_NONE - 0x0000 - no privilege ESS_PRIV_READ - 0x0001 - read data ESS_PRIV_WRITE - 0x0002 - write data ESS_PRIV_CALC - 0x0004 - calculate data ESS_PRIV_DBLOAD - 0x0010 - load and unload databases ESS_PRIV_DBDESIGN - 0x0020 - manage databases ESS_PRIV_DBCREATE - 0x0040 - create, delete, and edit databases ESS_PRIV_APPLOAD - 0x0100 - load and unload applications ESS_PRIV_APPDESIGN - 0x0200 - manage applications ESS_PRIV_APPCREATE - 0x0400 - create, delete, and edit applications ESS_PRIV_USERCREATE - 0x1000 - create, delete, and edit users
The access types are combinations of privileges. The valid values are: ESS_ACCESS_NONE - 0x0000 ESS_ACCESS_READ - 0x0111 ESS_ACCESS_WRITE - 0x0113 ESS_ACCESS_CALC - 0x0117 ESS_ACCESS_METAREAD - 0x0118 ESS_ACCESS_DBMANAGE - 0x0137 (also known as ESS_ACCESS_DBDESIGN, preserved for backward compatibility) ESS_ACCESS_DBCREATE - 0x0177 ESS_ACCESS_APPDESIGN - 0x0377 ESS_ACCESS_APPCREATE - 0x0777 ESS_ACCESS_FILTER - 0x0110 ESS_ACCESS_DBALL - 0x00ff - full database access ESS_ACCESS_APPALL - 0x0fff - full application/database access ESS_ACCESS_ADMIN - 0xffff - administrator (unrestricted access) (also known as ESS_ACCESS_SUPER, preserved for backward compatibility)
The Oracle's Hyperion® Shared Services security role mappings are:ESS_USERPROVROLE_NONE = ESS_ACCESS_NONE = 0x0000 ESS_USERPROVROLE_USERCREATE = ESS_PRIV_USERCREATE = 0x1000 Note: This role cannot be set by Essbase in Shared Services mode; it can only be set in Shared Services. ESS_USERPROVROLE_APPCREATE = ESS_PRIV_APPCREATE = 0x0400 ESS_USERPROVROLE_APPMANAGER = ESS_ACCESS_APPMANAGE or ESS_ACCESS_APPDESIGN = 0x0377 ESS_USERPROVROLE_APPLOAD = ESS_PRIV_APPLOAD = 0x0100 ESS_USERPROVROLE_DBFILTER = ESS_ACCESS_FILTER = 0x0110 ESS_USERPROVROLE_DBREAD = ESS_ACCESS_READ = 0x0111 ESS_USERPROVROLE_DBWRITE = ESS_ACCESS_WRITE = 0x0113 ESS_USERPROVROLE_DBCALC = ESS_ACCESS_CALC = 0x0117 ESS_USERPROVROLE_DBMANAGER = ESS_ACCESS_DBMANAGE or ESS_ACCESS_DBDESIGN = 0x0137 ESS_USERPROVROLE_ADMINISTRATOR = ESS_ACCESS_ADMIN or ESS_ACCESS_SUPER = 0xffff
|