...
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
| Content by Label | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...