ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating and setting up database users for the BIS in SQL Server Express

  • Creating SQL Server Express database users
  • Granting users geodatabase roles/permissions

Creating SQL Server Express database users

Use the following steps for creating users for the Bathymetry Information System (BIS) geodatabase in ArcCatalog on a database server (an instance of SQL Server Express).

  1. Start ArcCatalog.
  2. Right-click the database server where you want to add a user or group.

    Tip:

    If the Catalog window is not visible in ArcMap, you can open it by clicking the Catalog button Catalog on the Standard toolbar or by clicking Windows > Catalog on the main menu.

  3. Click Permissions.

    The Permissions dialog box appears.

  4. Click Add user.
  5. Specify the location where you want to search for the user or group.

    This can be the local machine or a domain.

  6. Type the name of the user or group you want to add.

    Tip:

    You can click the Advanced button to find the user you want using a more specific search.

  7. Click Check Names to verify that the login name is valid.
  8. Click OK.

Granting users geodatabase roles/permissions

After you have registered users with the SQL Server Express server, you will need to assign each of those users specific permissions based on their BIS role.

  1. Right-click the geodatabase for which you want to grant user permissions.
  2. Click Administration and click Permissions.
  3. Choose the desired user or group from the list on the Permissions dialog box.
  4. Click the appropriate role:
    • None—No specific access to the geodatabase or the datasets in the geodatabase has been granted.
    • Read Only—The user can only view and select data.
    • Read/Write—The user can read, write to, and create new datasets in a geodatabase or can read and write to an existing dataset.
    • Admin—The user can perform administrative tasks in a specific geodatabase.
    • Server administrator—This user manages the database server.
  5. Click Apply.
  6. Repeat steps 3 through 5 for each administrator and editor.
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal