topic Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission. in ArcGIS Enterprise Questions

"The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

MDB_GIS — Tue, 16 Apr 2024 13:21:36 GMT

One of my users is trying to add a new attribute field to data that is stored in a traditionally versioned enterprise SQL geodatabase. She has the exact same SQL server permissions that I do as far as I can tell. For some reason I can edit the schema, but she can't. Any ideas what is going on here?

Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

George_Thompson — Tue, 16 Apr 2024 13:36:59 GMT

If you are updating the schema of the feature class you need to connect as the data owner. Are you connecting as the data owner?

Are you both connecting as the same user to SQL Server?

Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

MDB_GIS — Tue, 16 Apr 2024 13:43:46 GMT

No. We are both connecting as OS authenticated users. So if I created the layer, there is no way at all for her to modify the schema? I created a layer with bare minimum attribution with the intent of allowing her to add only the attributes that are needed for the project as the need arises. I would really like for members of the core GIS team to be able to add fields to dataset as needed rather than have to wait for me to do it for them.

Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

George_Thompson — Tue, 16 Apr 2024 14:19:38 GMT

So if I created the layer, there is no way at all for her to modify the schema?

That is correct, only the data owner can update the schema. If the table is something like this: dbname."Domain\MattBeal".tablename then only you would be able to update.

If you want to have a list of users that can make the changes. You would need to load the data as a DB user / data owner. You could then share the UN / PW or a connection file, with those users that would allow access.

Just know that they would be able to full permissions on the table. Which means they can modify anything in the table properties, include deleting the table.

Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

ElmurodUrinboev — Tue, 24 Feb 2026 12:04:08 GMT

Dear Ser. Can you send me step by step how I can do it.

Re: "The table or feature class corresponding to the view is read-only." Data is in enterprise DB and user has read/write permission.

George_Thompson — Tue, 24 Feb 2026 14:49:25 GMT

Steps on copying data to another schema?