Guide

Database Administration Using Database Manager
Contact DeLorme Professional Sales for support: 1-800-293-2389 Page 93
Database Administration Using Database Manager
This section describes common DeLorme OpenSpace Database administration tasks that can be
accomplished using the Database Manager application that installs with XMap.
Topics include: Managing SQL Server User Roles, Managing Database User Roles, and Backing Up and
Restoring Databases.
Refer to the XMap Help section Database Manager Overview for additional Database Manager tasks and
detailed information.
If you use a third party application to administer your OpenSpace Databases, this section does not apply
to you.
Managing SQL Server (System) User Roles
Three server roles can be configured by a Server Administrator using Database Manager:
Server User (default)—This is the default server role given to a user when they are added to the SQL
server list. Server Users can log in and access any databases to which they have been granted access,
but they cannot create or delete (drop) databases. Their permissions on each database are governed by
the database role they have been assigned by a Server Administrator.
Database Creator—Database creators are automatically assigned XMap Owner database roles on the
databases they create and have full access to these databases, including deleting databases, enabling
subscriptions, enabling check-outs, and changing database permissions of other users on the database.
Permissions on databases that they did not create are governed by the database role they have been
assigned by a Server Administrator.
Server Administrator—Server administrators have full access to the server and owner rights to any
databases on the server. They can add and remove server users and assign server roles to other users,
as well as enable subscriptions on databases. Note that System Administrators on the computer where
the SQL server resides are automatically granted SQL Server Admin and Database Owner rights.
To add a new user to the SQL server, expand the server list in the tree menu to the left, point to Server
Users, then right-click New User.