Is This Content Helpful?
We're glad to know this article was helpful.
Instructions provided below describe how to add a new user to a PostgreSQL geodatabase using the psql interactive terminal.
The psql PostgreSQL interactive terminal can be used to create additional users in a PostgreSQL ArcSDE geodatabase. The commands in this How To article will:
- Create a user and assign a password.
- Create a schema for the user if that user will own data within the geodatabase.
- Assign appropriate privileges so that other users can access the data in the newly created user's schema.
This article assumes that PostgreSQL has already been installed, and the ArcSDE for PostgreSQL Post Installation program has been run successfully.
Follow the steps below:
CREATE ROLE username LOGIN PASSWORD 'password' NOINHERIT CREATEDB;
CREATE SCHEMA username AUTHORIZATION username;
GRANT USAGE ON SCHEMA username TO PUBLIC;
GRANT SELECT, INSERT, UPDATE, DELETE ON public.Geometry_columns TO username;