Register With Geodatabase fails due to lack of permission

Question

I have a user called "user1" that creates a non-spatial table (it just contains tabular data) on SCHEMA-x on Postgresql.

Now, I want to register this table so that the geodatabase can read it.

Here is the privilege that I have granted:

GRANT USAGE ON SCHEMA sde TO user1;
GRANT USAGE ON SCHEMA SCHEMA-x TO user1;
GRANT SELECT, INSERT, UPDATE, DELETE ON new_table TO sde;

I login to SDE from Arcgis Pro 11.0 using the owner of SCHEMA-x . I then use tool Register With Geodatabase. This comes up "ERROR 160228: The user does not have permission to execute the operation."

So, what do I miss ?

VinceAngelo · Accepted Answer

Table ownership and schema are different things in PostgreSQL. ArcObjects geodatabase registration functionality requires that the schema be the same as the owner login. You can use the tables without registration, or you can name them as required for registration.

- V