Skip Navigation

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
    .