Configuring SQL 2000 for use with ESRI ArcSDE

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?
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?
>