Granting Configuration Manager database permissions

Home Forums Callisto as a Service Granting Configuration Manager database permissions

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #276
    CallistoAdmin
    Keymaster

    Callisto, as with other reporting solutions, requires read access to the Configuration Manager database. If you need to grant these permissions to your users, the simplest thing to do is to create a group, in Active Directory, for example “Callisto Users” and grant this group rights to read the SQL DB using SQL Enterprise Manager and running this script, edit the bits in italics to reflect your domain and ConfigMgr DB name.

    USE MASTER
    CREATE LOGIN [domain\Callisto Users] FROM WINDOWS;

    USE CM_DB1
    CREATE USER [domain\Callisto Users];
    ALTER ROLE db_datareader ADD MEMBER [domain\Callisto Users]

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.