MicroStrategy ONE

Security Views: Windows Authentication and Linked Warehouse Login

You may want to use this configuration if you are using security views to implement access control policies for data. For example, two different users executing the same SQL query receive different results, reflecting their different levels of access. For the security views to work, each report is executed under the RDBMS account of the user who submitted the report from the MicroStrategy system. Even though this approach requires users to have accounts on the RDBMS, you may choose to use Windows authentication so that users do not have to remember their RDBMS login ID and password when logging in to the MicroStrategy system. With Windows authentication, users are automatically logged in to the MicroStrategy system using their Windows ID and password.

For detailed information about security views, see Controlling Access to Data at the Database (RDBMS) Level.

To Establish the Configuration

  1. In Developer, open the Project Source Manager, and on the Advanced tab, select Use network login ID (Windows authentication) as the Authentication mode.
  2. From Web, log in as an administrator and select Preferences, select Project Defaults, select Security, and then enable Windows Authentication as the login mode.
  3. In Developer, in the User Editor, expand Authentication, then select Warehouse.
  4. Link users to their respective database user IDs using the Warehouse passthrough Login and Warehouse passthrough password boxes for each user. For details on each option, click Help.
  5. Enable the setting for database execution to use linked warehouse logins on each project that you want to use linked warehouse logins for database execution. To do this, right-click the project and select Project Configuration, expand the Database instances category, click Execution, and select the Use linked warehouse login for execution check box.