POST
|
Many thanks Asrujit - I'll take a look at that. Ben, Open SQL Server management Studio--> Connect to the Instance-->Expand Databases-->R-Click on the required database-->Properties-->Permissions-->Select the user you want to revoke the permissions from--> Scroll down in the permissions list below and revoke the permissions under the "GRANT" tab here. Mainly, the user shouldn't have: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW Hope this helps! Regards,
... View more
06-20-2013
07:10 AM
|
0
|
0
|
450
|
POST
|
Many thanks again Shannon - most helpful. I'm fairly familiar with using SSMS write SQL queries to get to data, but haven't done any DBA work so the REVOKE/GRANT syntax is what was seeking. I will review the documentation you provided, too. Again - thank you. If you are going to be administrating a geodatabase on SQL Server I strongly suggest becoming comfortable using Management Studio and basic SQL. The tools provided in ArcGIS are useful under very specific circumstances, and only cover a few tasks. If you go to either the properties of a database (permissions page), or the properties of a user (securables page), you'll be able to see a list of database-level DDL permissions that have been assigned to them, either explicitly, or effectively by way of role membership. Here you can grant, revoke or deny permission. But, the easier way is to use the query window and execute something like this: REVOKE CREATE TABLE, CREATE PROCEDURE, CREATE VIEW FROM myuser For more information on users in geodatabases there are several topics in the Geodata section of the online documentation. I'd start here: http://resources.arcgis.com/en/help/main/10.1/index.html#/What_are_user_privileges/002q0000002r000000/ and here: http://resources.arcgis.com/en/help/main/10.1/index.html#/User_privileges_for_geodatabases_in_SQL_Server/002q0000002s000000/ -Shannon
... View more
06-20-2013
07:08 AM
|
0
|
0
|
450
|
POST
|
Shannon - hi. Many thanks for your reply. I did indeed use that tool to create the user accounts. I guess I'm not familiar enough with Management Studio to work out how to revoke those permissions (I tried setting their database role membership only to db_datareader but that didn't appear to do anything). Do you have any guidance on how to revoke the permissions correctly in SSMS? Thanks again - really appreciate it! Kind regards, Ben
... View more
06-19-2013
02:30 PM
|
0
|
0
|
450
|
POST
|
Hi there, I am trying to work out whether there is a way to set Global permissions for viewer and editor roles so that they cannot create new data in the database. Some context: I am on v10.1, using an ArcSDE database with SQL Server 2008 R2 back-end. I have set up 3 roles (Viewer, Editor and Creator) through ArcCatalog, and have also set up some users that I have assigned to these roles (one account that is used to create data, a few editor accounts, and as many viewer accounts as are required). Having created a Feature Dataset with the 'Creator' account, and set the permissions on the dataset appropriately, I have verified that neither the editor account or the viewer accounts can delete or add data to the feature dataset - All good so far! However, I discovered that both the viewer and editor accounts ARE able to create their own data in the root of the geodatabase, and then do whatever they want with that data. Not really what I want!! I have also tried using SQL Server Management Studio to limit permissions on the roles, but to no avail. Any ideas? Thanks and kind regards, Ben
... View more
06-19-2013
01:30 PM
|
0
|
6
|
1017
|
POST
|
John and Steve, Many thanks to you both for your suggestions. I'll try them and report back when I get a chance. I suspect that there's a small mistake in my code somewhere that is causing issues, but we shall see! Kind regards, Ben
... View more
08-22-2012
06:14 AM
|
0
|
0
|
201
|
POST
|
Hi there, I'm refreshing my memory of the JSAPI through the Building Webmaps with the JavaScript API course materials... I have encountered an issue whereby if I reference the v2.1 API (as in the course materials) the datagrid displays correctly with black text on a white background. But when I change it to reference v3.1 API, the text is white on white. Has anyone else encountered the white-on-white text issue in data grids with v3.1? If so, how do I get around this? Thanks and kind regards, Ben
... View more
08-17-2012
07:54 AM
|
0
|
3
|
528
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|