Type of user |
Database permissions |
Dataset permissions |
Notes |
Data viewer |
- USAGE on sde schema
- USAGE on all other schemas that contain data to which data viewers need access
|
SELECT on specific datasets |
|
Data editor |
- USAGE on sde schema
- USAGE on all other schemas that contain data editors need to access
|
SELECT, INSERT, UPDATE, and DELETE on other users' datasets |
|
Data creator |
- USAGE on sde schema
- USAGE on all other schemas that contain data that data creators need to access
- CREATEDB
|
|
If using PostGIS geometry type, you must also grant SELECT, INSERT, UPDATE, and DELETE on the public.geometry_columns table. (Syntax = GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO <user_name>) |
ArcSDE administrator |
USAGE on all other user schemas |
|
If this is not granted, the ArcSDE administrator will not be able to compress the database. |
NOTE: CONNECT on database is granted to PUBLIC by default. If you revoke this privilege from PUBLIC, you will need to explicitly grant CONNECT on databases to specific groups and/or roles.