Re: Configuring SQL 2000 for use with ESRI ArcSDE
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/11/04
- Next message: Dan Guzman: "Re: Developer design Best Practices"
- Previous message: Andras Jakus: "Re: Running job or DTS package on remote/other server of cluster"
- In reply to: Joe16: "Configuring SQL 2000 for use with ESRI ArcSDE"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 11 Sep 2004 10:29:22 -0500
You can assign SQL Server users to database roles using sp_addrolemember:
USE SDE
EXEC sp_addrolemember 'Viewer', 'SomeUser'
GO
Permissions are entirely application specific. I assume these roles are
pre-defined by the app and appropriate object permissions assigned. Your
application documentation should specify if any additional permissions (e.g.
CREATE) are needed by application users. If the app doc doesn't contain
this information and you have security issues, I suggest to contact the
vendor for clarification of security requirements. You might get lucky with
a knowledgeable ESRI user in this forum but your vendor is the authoritative
source.
-- Hope this helps. Dan Guzman SQL Server MVP "Joe16" <Joe16@discussions.microsoft.com> wrote in message news:D0F741EF-8DAA-4630-A6EA-49564330B345@microsoft.com... > Rookie here..... > I need help making some changes so that security is enabled on the ESRI > side. My problem is this. I have Two databases (SDE and Vector) 3 Roles > (Viewer, Editor 1 and Editor 2) and multiple users/logins. I can not find > any documentation which specifies how I assigne users to roles. In > addition, > I can not find out which users in which databases should have Create > Table, > Create Function Create SP, etc.... > Any one have any good resources I can look at? > >
- Next message: Dan Guzman: "Re: Developer design Best Practices"
- Previous message: Andras Jakus: "Re: Running job or DTS package on remote/other server of cluster"
- In reply to: Joe16: "Configuring SQL 2000 for use with ESRI ArcSDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
