Create Database User (Data Management)

This ArcGIS 2.8 documentation has been archived and is no longer updated. Content and links may be outdated. See the latest documentation.

Summary

Creates a database user with privileges sufficient to create data in the database.

Usage

  • This tool can be used only with Oracle, Microsoft SQL Server, PostgreSQL, or SAP HANA. This tool is not supported with cloud-based database services.

  • For Oracle and SQL Server, if an operating system login exists, the Create Database User tool can add that login as a user to the specified database.

  • You cannot create a database user for a Microsoft Windows group.

  • This tool creates shared log file tables for the user when run on a geodatabase in Oracle.

  • Users created in the database have the following privileges granted to them:

    DBMSPrivileges

    Oracle

    CREATE PROCEDURE

    CREATE SESSION

    CREATE SEQUENCE

    CREATE TABLE

    CREATE TRIGGER

    CREATE VIEW

    SELECT ON DBA_ROLES

    PostgreSQL

    CONNECT

    TEMPORARY

    USAGE on the sde schema if the user is created in a geodatabase or a database that has the ST_Geometry type installed

    SELECT, INSERT, UPDATE, and DELETE on the geometry_columns and geography_columns views and SELECT on the spatial_ref_sys view if PostGIS is installed in the database

    SQL Server

    CREATE TABLE

    CREATE PROCEDURE

    CREATE VIEW

    SAP HANA

    The tool creates an SAP HANA standard user.

  • If the login does not exist in the SQL Server instance or PostgreSQL database cluster, the Create Database User tool adds the login, creates a user in the database specified for the Input Database Connection parameter, and creates a schema for the user in the database. The specified database is set as the user's default database in SQL Server.

  • If the login exists in the SQL Server instance, the Create Database User tool adds the user to the database specified for the Input Database Connection parameter and creates a matching schema. The user's default database is not changed in SQL Server.

  • If the login exists in the PostgreSQL database cluster, the Create Database User tool creates a matching schema in the database specified for the Input Database Connection parameter.

  • You cannot create a user named sde with this tool. The sde user is a geodatabase administrator user and requires more privileges than the Create Database User tool grants.

  • You cannot use delimiters, such as double quotation marks, when specifying a user name. The user name can only contain characters supported by the underlying database management system when provided without delimiters.

Parameters

LabelExplanationData Type
Input Database Connection

The connection file to an enterprise geodatabase in Oracle, PostgreSQL, or SQL Server. Be sure the connection is made as a database administrator user. When connecting to Oracle, you must connect as the sys user.

Workspace
Create Operating System Authenticated User
(Optional)

Specifies the authentication type for the user. Use this parameter only if an operating system login exists for which you want to create a database user. This option is only supported for SQL Server and Oracle databases, as those are the only two databases for which ArcGIS supports operating system authentication.

  • Checked—An operating system-authenticated user is created. The corresponding login must already exist.
  • Unchecked—A database-authenticated user is created. This is the default.
Boolean
Database User

The name of the new database user.

If you chose to create a database user for an operating system login, the user name must match the login name.

String
Database User Password
(Optional)

The password for the new user. The password policy of the underlying database is enforced.

If you chose to create a database user for an operating system login, no input is required.

Encrypted String
Role
(Optional)

To add the new user to an existing database role, specify the name of the role.

String
Tablespace Name
(Optional)

When creating a user in an Oracle database, type the name of the tablespace to be used as the default tablespace for the user. You can specify a preconfigured tablespace, or, if the tablespace does not yet exist, it will be created in the Oracle default storage location with its size set to 400 MB. If no tablespace is specified, the user's default tablespace will be set to the Oracle default tablespace.

String

Derived Output

LabelExplanationData Type
Database User Created

Whether the tool completed successfully.

Boolean

Environments

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics