nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

"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

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?

Find more posts tagged with

Accepted answers

George Thompson

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.

All comments

ElmurodUrinboev

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

George Thompson

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

MDB_GIS

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.

George Thompson

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.