Register With Geodatabase fails due to lack of permission

[yockee]

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 ?

[George_Thompson]

I am wondering if "SCHEMA-x" (table owner) needs to have the same permissions as a data owner to "own" the object in the geodatabase; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/privileges-postgre...

If you update SCHEMA-x's permissions to that of a data owner and re-run the tool, does that work?

[VinceAngelo · Accepted solution]

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