Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry UEM 12.13
  3. Installation and Configuration
  4. BlackBerry UEM Installation and Upgrade
  5. Preinstallation and preupgrade tasks
  6. Configuring connections for the BlackBerry UEM database
  7. Configuring database permissions using Microsoft SQL Server roles
  8. Configure minimum database permissions for the service account or Microsoft SQL Server account

Configure minimum database permissions for the service account or 
Microsoft SQL Server
 account

You can configure minimum database permissions for the service account or 
Microsoft SQL Server
 account that 
BlackBerry UEM
 uses to connect to the 
BlackBerry UEM
 database.
Add a different 
Windows
 account or 
Microsoft SQL Server
 account to the db_owner database role for the 
BlackBerry UEM
 database.
  1. Open the 
    Microsoft SQL Server Management Studio
    .
  2. Expand 
    Microsoft SQL Server > Security > Logins
    .
  3. Right-click the service account or 
    Microsoft SQL Server
     account. Click 
    Properties
    .
  4. Click 
    User Mapping
    . Select the 
    BlackBerry UEM
     database.
  5. In the 
    Users mapped to this login
     section, select 
    bes
    .
  6. In the 
    Database role membership for
     section, select 
    rim_db_bes_server
    .
  7. Remove all other database role memberships except for rim_db_bes_server and public.
  8. Click 
    OK
    .