topic Re: Insufficient Permissions?? in ArcGIS Enterprise Questions

Insufficient Permissions??

AndreGirard — Wed, 07 Feb 2018 14:32:17 GMT

I'm trying to add a field into an existing feature and when doing so i get the following error:

We are on ArcSDE with SQL being the server DBMS.

I'm on ArcGIS Desktop 10.5.1

IT department has looked into things on the database & server side and haven't found anything out of the norm.

Any help would be appreciated

Thanks

Re: Insufficient Permissions??

George_Thompson — Wed, 07 Feb 2018 14:42:04 GMT

Are you connected as the data owner? What are your permissions according to ArcCatalog on the feature class.

There are some notes at the top of the help that may be present: Adding fields—Help | ArcGIS Desktop

You can add or remove fields as long as the following conditions are met:
You have write access to the data.
You're not currently editing the data in ArcMap.
No other users or applications are accessing the data including other ArcMap or ArcCatalog sessions.

Re: Insufficient Permissions??

AdrianWelsh — Wed, 07 Feb 2018 14:42:47 GMT

This almost seems like a database lock-up type of issue. It might be best to move this thread to ArcGIS Enterprise‌

(or maybe Enterprise GIS?? - things are tricky on the GeoNet sometimes...)

Is there a way to stop/start the database and try again?

Or maybe this article can help:

Manage geodatabase locks—Help | ArcGIS Desktop

Re: Insufficient Permissions??

AndreGirard — Wed, 07 Feb 2018 14:52:58 GMT

Well i looked into the locks and there is nobody locking the database.

Will have IT restart the database server and see how that goes.

Thanks

Re: Insufficient Permissions??

MichaelVolz — Wed, 07 Feb 2018 15:07:17 GMT

Did you check to see if there are any patches for your version that might address this issue?

Re: Insufficient Permissions??

George_Thompson — Wed, 07 Feb 2018 15:13:52 GMT

Here is a patch that has some permissions fixes for SQL Server: Esri Support 10.5 (10.5.1)

Re: Insufficient Permissions??

AndreGirard — Wed, 07 Feb 2018 16:25:16 GMT

ran the patch and that did not resolve the problem.

Server will be restarted overnight and will update tomorrow as to where things stand

Thanks

Re: Insufficient Permissions??

TinaMorgan1 — Thu, 08 Feb 2018 18:06:35 GMT

This is a SQL Server geodatabase? In the error the object you are trying to alter is GIS_Essex_power.dbo.sw_cubicle.Test_report

^I can't tell if the owner is 'dbo' or 'sw_cubicle'. SQL Server fully qualified naming conventions are database.schema.object

What is the full name of your database, schema and object. Are there periods in any of these names?

Have you ever been able to alter this object?

Re: Insufficient Permissions??

AndreGirard — Thu, 08 Feb 2018 18:59:12 GMT

The full name is GIS_Essex_Power.DBO.SW_CUBICLE

I was trying to add another field called "TEST_REPORT"

We recently upgraded to 10.5.1

I haven't had to any fields in quite some time so not sure if this is tied to the upgrade or another problem or not.

Re: Insufficient Permissions??

TinaMorgan1 — Thu, 08 Feb 2018 19:01:56 GMT

Can you make sure that your user is still associated with the dbo schema? This can be confirmed in SQL Server Management Studio.

Re: Insufficient Permissions??

GelcysWilliams — Wed, 30 Jan 2019 16:55:05 GMT

I'm hitting this error now on a db I have permissions to edit - I can't add a new feature class. How did you guys resolve? I see a 13 in the error, I'm going to hunt for a SQL Native Client 13 maybe??? Let me know if I'm on the right track??

Re: Insufficient Permissions??

MichaelVolz — Wed, 30 Jan 2019 17:00:57 GMT

Did you just recently perform an ArcGIS upgrade?

Did you apply the patch mentioned above?