Databases authenticate ArcGIS Server web service connections using the credentials you provide when you register the database with the ArcGIS Server site as follows:
- If you use database authentication, the database user name and password you provide when you register the database is used to authenticate the connection.
- If you use operating system authentication, the service connects to the database using the ArcGIS Server account. For ArcGIS Server sites running on Microsoft Windows machines, this is the login that runs the ArcGIS Server Windows service. For ArcGIS Server sites running on Linux machines, this is the account you logged in with when you installed ArcGIS Server.
The database user or ArcGIS Server account must have privileges to connect to the database and select data to be published. If you publish editable feature services, the database user or ArcGIS Server account also must have privileges to edit the published data.
See the following information in the ArcGIS Pro or ArcMap help to determine the privileges the registered user or ArcGIS Server account requires to allow web services to access data in a database.
For read-only services (map services or feature services that do not have editing enabled), grant the privileges required for a data viewer. For editable feature services, grant the privileges required for data editors.
- Privileges for using ArcGIS with Dameng
- Privileges for using ArcGIS with a Db2 database
- Privileges for using ArcGIS with an Informix database
- Privileges for using ArcGIS with an Oracle database
- Privileges for using ArcGIS with a PostgreSQL database
- Privileges for using ArcGIS with an SAP HANA database
- Privileges for using ArcGIS with a SQL Server database
- Privileges for using ArcGIS with Teradata