Can I grant privileges for geodatabase dataset stored in enterprise SQL Sever with SQL but not arcgis client or python script?

gaofangwan — Wed, 01 Apr 2020 03:53:30 GMT

Sir who will deal with it:

According to offical document, there are three ways to grant and revoke dataset privileges as follows:

What I want to know is, when geodataset stores in enterprise SQL server with sde, if I can grant and revoke dataset privileges with SQL statement like

Use xxx

Grant SELECT, INSERT, UPDATE, DELETE on xxx.xxx.xxx To xxx

Here is the document of Microsoft SQL server.

Re: Can I grant privileges for geodatabase dataset stored in enterprise SQL Sever with SQL but not arcgis client or python script?

VinceAngelo — Wed, 01 Apr 2020 04:49:35 GMT

Well, you could, but probably not through an Esri API. The "USE database" is incompatible with the Enterprise geodatabase connection file (.sde) being linked to a specific database.

In theory, the USE isn't required, so an arcpy.ArcSDESQLExecute() request could issue the GRANT command, but the principal benefit of using an Enterprise geodatabase is to take advantage of versioning and geodatabase behaviors, and only a tool like ChangePrivileges is going to know which tables participate in geodatabase functionality, so if you roll your own, you might have permission issues later on down the road (for example, feature datasets have the permission of the least access of the members, so if you miss one GRANT, you might not have any access at all).

- V

topic Can I grant privileges for geodatabase dataset stored in enterprise SQL Sever with SQL but not arcgis client or python script? in Developers Questions

Can I grant privileges for geodatabase dataset stored in enterprise SQL Sever with SQL but not arcgis client or python script?

Re: Can I grant privileges for geodatabase dataset stored in enterprise SQL Sever with SQL but not arcgis client or python script?