Access ArcGIS Server data using Visual Studio: Difference between revisions
From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs) mNo edit summary |
Brian Wilson (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
View-> | View-> SQL Server Object Explorer | ||
== See the roles attached to a geodatabase == | == See the roles attached to a geodatabase == | ||
| Line 12: | Line 12: | ||
WHERE type = 'R' and principal_id>0 and principal_id<16384; | WHERE type = 'R' and principal_id>0 and principal_id<16384; | ||
To run it, you can click the "play" button in the top bar. | To run it, you can click the grey "play" button in the top bar on the window (not the green Start button). | ||
Here is a screen shot after the query runs. | Here is a screen shot after the query runs. | ||
Revision as of 18:44, 13 July 2018
View-> SQL Server Object Explorer
See the roles attached to a geodatabase
Select the ArcGIS database you want to look at.
Right click and select "New Query...".
This opens a SQL query window. You can then type this in:
SELECT [name] FROM sys.database_principals
WHERE type = 'R' and principal_id>0 and principal_id<16384;
To run it, you can click the grey "play" button in the top bar on the window (not the green Start button).
Here is a screen shot after the query runs.
