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
Grant SELECT, INSERT, UPDATE, DELETE on xxx.xxx.xxx To xxx
Here is the document of Microsoft SQL server.