Create a Database User

Now that the enterprise database is created, you need to create a new database user. The connected user must be the owner of the Utility Network and this user cannot have the DBO role.

Enterprise geodatabase user details:

1. Open the Geoprocessing window and enter Create Database User in the search bar. Open the tool.

2. Enter the required fields and click Run.

   • For Input Database Connection, on the Catalog pane under Databases, drag the enterprise geodatabase name to the Create Database User window.

   • For Database User, enter the name of the Database user.

   • For Database User Password, assign a password to the new user.

   • Role is optional.

   

3. In the Catalog pane, under Databases, right click the current database connection and select Remove from Project.

   You are going to create a connection with the new database user login.

4. Save your project, close, and reopen ArcGIS Pro.

5. Right click Databases and select Create New Database Connection.

   • Instance is the URL of the database server.

   • Authentication Type is Database authentication.

   • User Name is the new database user credentials.

   • Password is the new database user credentials.

     Make sure the Save User/Password box is enabled.

   • Database is the name of the database you want to connect to. Select the name from the menu.

   • Connection file name automatically populated.

     

   The name of the database now has the user login in parenthesis. Example: SQLServer-mydatabasename(fiber_user).sde where fiber_user is the name of the new database user.