This article contains general information about database requirements for Simplify Suite and also describes the required permissions for Microsoft SQL Server for proper installation and operation of Simplify Suite.
...
During the creation of the database, permission to use the database and execute stored procedures is granted to all authenticated users via the GRANT EXECUTE TO [NT AUTHORITY\Authenticated Users] SQL command.
This is so SQL Server stored procedures installed in the database can execute without disruption or error.
...
After installation or upgrade of Simplify Suite, the least-required SQL permissions needed for most customers to launch Simplify Console are 'db_datareader' and 'db_datawriter'.
End users Users can be granted only 'db_datareader' access, in which case the Simplify Console becomes a read-only tool suitable for viewing only.
The SQL Login ID must also have permission to execute the stored procedures within the Simplify database.
To grant this permission do this, the following query can be used:
USE [<database name>]
GRANT EXECUTE TO [<SQL Login ID>]
Example:
USE [Simplify]
GRANT EXECUTE TO [TriceratDatabaseUser]
Related articles
| Filter by label (Content by label) | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...