Creating and setting up database users for the BIS in SQL Server Express (Bathymetry Solution)

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).

Steps:

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 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.

Steps:

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.