BI360 components that access the BI360 Data Warehouse applications, such as the Reporting components will require read permissions (db_datareader) to the SQL database, while the Data Warehouse Manager and Planning components will additionally require write (db_datawriter) and execute permissions.
Granting db_datareader and db_datawriter roles will not achieve the necessary permissions, as both the Data Warehouse Manager and Planning execute stored procedures, thus a role called "BI360_Users" is created upon creation of the Data Warehouse via the installation wizard that will allow a DBA to map all users to this role, ensuring that all BI360 users have sufficient permissions to use the application.
This user has the following permissions:
- GRANT CREATE PROCEDURE
- GRANT CREATE TABLE
- GRANT DELETE
- GRANT EXECUTE
- GRANT INSERT
- GRANT REFERENCES
- GRANT SELECT
- GRANT UPDATE
- GRANT CREATE VIEW
Any user mapped to this role on the BI360 Data Warehouse database will have enough permissions to use the BI360 Application off the BI360 Data Warehouse database.
Note: In previous versions, the role was created as sods_user.
Applies to: Planning/Data Warehouse Manager