Create Role (Data Management)

ArcGIS Pro 3.4 | | Help archive

Summary

Creates a database role, allowing you to add users to or remove them from the role.

Usage

  • This tool can be used with Oracle, Microsoft SQL Server, or PostgreSQL only.

  • You cannot use delimiters, such as double quotation marks, when specifying the role. The role 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 a database or enterprise geodatabase. Connect as a database administrator user.

Workspace
Role

The name of the database role to create. If it's an existing role, type the name for the role you want to add users to or remove them from.

String
Grant To or Revoke From User(s)
(Optional)

Specifies whether the role will be added to a user or list of users or a user or list of users will be removed from the role.

  • Grant roleThe role will be granted to the specified user or users, making them a member of the role. This is the default.
  • Revoke roleThe role will be revoked from the specified user or users, removing them from the role.
String
User Name(s)
(Optional)

The name of the user whose role membership will change. To specify multiple users, type the user names separated by commas (no spaces).

String

Derived Output

LabelExplanationData Type
Create Role Succeeded

Whether the tool completed successfully.

Boolean

Environments

Licensing information

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

Related topics