Versions Compared

Key

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

This article describes the required permissions for SQL Server for proper installation and operation of the 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.

If the SQL Server Login ID does not have sufficient privileges a message box is displayed and the installation will not proceed.  

...

If the version upgrade requires a change to the database schema, customers will need to install the upgrade on each machine where the Simplify Console is installed.  This is because the Simplify Console uses a version check to help ensure it is compatible with the Simplify Suite database.

Running the Simplify Suite Console

Any authenticated user can run the Simplify Console.  There are no SQL Login IDs required and no special privileges requiredSimplifyConsole.exe program; there are no UAC "As Administrator" requirements.  The authenticated user must have the proper SQL database permissions of public and db_datareader to open and see the configured objects and assignments.  If they wish to edit objects or assignments, they will need db_datawriter permissions as well.

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

...