Essbase® Analytic Services Database Administrator's Guide | | Update Contents | Previous | Next | Print | ? | |
Information Map | |
This chapter describes some sample security problems and solutions, which are based on the Sample application. These examples use security procedures described in Managing Security for Users and Applications.
Three employees need to use Analytic Services-Sue Smith, Bill Brown, and Jane Jones. Each requires update access to all databases in the Sample application.
Because the users need update access to only one application, they do not need to have Supervisor permission. Because the users do not need to create or delete applications, users, or groups, they do not need to be defined as special types of users with Create/Delete permission. All these users need is Application Designer permission for the Sample application.
The supervisor should perform the following tasks:
For more information, see Essbase Administration Services Installation Guide.
If Sue, Bill, and Jane are created without Application Designer permission, assign Application Designer permission to the three users.
For more information, see Creating Users or Granting Designer Permissions to Users and Groups.
Three employees need to use Analytic Services-Sue Smith, Bill Brown, and Jane Jones. Sue and Bill require full access to all databases in the Sample application. Jane requires full calculate access to all databases in the Sample application, but she does not need to define or maintain database definitions.
The supervisor should perform the following tasks:
If Sue and Bill are created without Application Designer permission, assign Application Designer permission to the two users.
For more information, see Creating Users or Granting Designer Permissions to Users and Groups.
See "Setting Minimum Permissions for Applications" in the Essbase Administration Services Online Help.
For more information, see Creating Users.
Three employees need to use Analytic Services-Sue Smith, Bill Brown, and Jane Jones. Sue and Bill require full access to all databases in the Sample application. Jane requires full update and calculate access to all databases within the Sample application, but she will not define or maintain the database definitions. Additional users will be added, all of whom will require Read access to all databases.
Because the current users have different needs for application and database access, define their user permissions individually. Then, to save time assigning individual Read permissions for future users, make Read the global setting for the application. (It does not matter in what order you assign the user permissions and the global access.)
The supervisor should perform the following tasks:
For more information, see Essbase Administration Services Installation Guide.
For more information, see Creating Users and Granting Designer Permissions to Users and Groups.
For more information, see Creating Users and Granting Application and Database Access to Users and Groups.
See "Setting Minimum Permissions for Databases" in the Essbase Administration Services Online Help.
Three employees need to use Analytic Services-Sue Smith, Bill Brown, and Jane Jones. Sue requires full access only to the Sample application; Jane requires calculate access to all members of the Basic database; Bill requires Read access to all members. No other users should have access to the databases.
Furthermore, Jane and Bill need to run report scripts that are defined by Sue.
Because the different users have different needs for application and database access, define the global access setting as None, and assign the user permissions individually.
The supervisor should perform the following tasks:
For more information, see Essbase Administration Services Installation Guide.
For more information, see Creating Users and Granting Designer Permissions to Users and Groups.
For more information, see Creating Users and Granting Application and Database Access to Users and Groups.
For more information, see Creating Users and Granting Application and Database Access to Users and Groups.
The Supervisor, Sue Smith, needs to perform some maintenance on the Sample application. She must make changes to the database outline and reload actual data. While she changes the application, Sue must prevent other users from connecting to the application.
Sue should perform the following tasks:
For more information, see "Clearing Applications of User Activity" in the Essbase Administration Services Online Help.
If any users have active locks, Sue's calculation or data load command might halt, waiting for access to the locked records. Sue can allow the users to complete their updates or clear their locks.
For more information, see "Viewing Data Locks" in the Essbase Administration Services Online Help.
![]() |