MSSQL Server
Permissions
Suite Database Upgrade tool
The Suite Database Upgrade tool must have following SQL database rights. Also take care of sufficient quota on the default table space of the upgrade user.
use master,
create login LoginName with password='Plan$QL', default_database=DatabaseName;
Go
use [DatabaseName];
Create User UserName FROM LOGIN LoginName
exec sp_addrolemember 'db_owner', 'UserName ';
Go
Planon application
The Planon application user must have the following SQL database rights. Also take care of sufficient quota on the default table space of the Planon application user.
use master
create login LoginName with password='Plan$QL', default_database=DatabaseName
Go
use master;
Grant View Server State To LoginName;
Go
use [DatabaseName];
Create user UserName for login LoginName;
Go
use [DatabaseName];
GRANT CONNECT TO UserName
Go
use [DatabaseName];
GRANT SELECT,INSERT,UPDATE,DELETE TO UserName;
Go
use [DatabaseName];
GRANT EXECUTE TO UserName;
Go