AnsweredAssumed Answered

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

Question asked by gaofangandy.wan on Mar 31, 2020
Latest reply on Mar 31, 2020 by vangelo-esristaff

Sir who will deal with it:

 

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

1.Use the Privileges dialog box

2.Use the Change Privileges tool

3.Use a Python script

 

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.

Outcomes