Privileges for using ArcGIS with ALTIBASE

Privileges determine what a user is authorized to do with the data and the database. Assign privileges based on the type of work the person does within the organization.

Users connecting to ALTIBASE from ArcGIS require system access and access to specific user data. As an ALTIBASE administrator, you create groups based on what users need to do in the database, grant privileges to the groups, and add the appropriate database users to each group.

The following table lists three groups of users who will connect from ArcGIS and the minimum privileges they require to query, edit, or create data.

Tip:

ALTIBASE grants CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, and CREATE VIEW privileges by default to new users. You only need to grant these privileges if you revoked them after creating the user.

Type of user	Required privileges	Purpose
Data viewer	CREATE SESSION	This privilege allows users to connect to the database.
	SELECT on other users' tables	Data viewers need select privileges on specific tables you want them to see and query.
Data editor* Data editors require the same privileges as data viewers, plus these additional privileges.	INSERT, UPDATE, DELETE on other users' tables	Grant the editing operations you want editors to perform on specific tables.
	CREATE SESSION	This privilege allows users to connect to the database.
Data creator	CREATE TABLE DROP TABLE CREATE SEQUENCE CREATE PROCEDURE	These privileges allow data creators to create tables and feature classes in the database, and populate ObjectID fields.

*You can edit data published to an ArcGIS Server feature service that has editing operations enabled.

If data creators will be creating views to restrict the amount of data returned from the database to the ArcGIS client, grant them CREATE VIEW and DROP VIEW privileges.