Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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]


Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("sql","db","permissions") and type = "page" and space = "TKB"

...