New SDE user for existing install of sde

[MartinAshmore]

Hi,

I've been searching the help but cant find any detailed information on setting up a new user in SDE. The documentation seems to say you need to do this in your database but does not elaborate further.

If someone knows of a guide or can offer some pointers that would be much appreciated.

Background

ArcSDE version 9.2 with SQL Server 2005 on Windows Server 2003

Until now all of the data held in our geodatabase has been issued to users with a read only connection and updated centrally. However the property team now need to makes changes to their layer directly.

To give access only to this layer I am intending on creating a new property sde user, to which I will grant editting privelages for the layer in question.

So far i have established that the new user needs to be created in sql server, but I dont know how to do this. Any tips/pointers would be appreciated.

Many thanks,

Martin Ashmore.

[NanaDei]

Hi Martin,

You can review the following blog for steps in creating a new sql server login and mapping the login to a database.

---
http://seablick.com/blog/71/a-newbies-guide-to-installing-dotnetnuke.aspx

Section 2 has information for performing this operation.
========
2. Create the Database, SQL Server Login, and Database User
> Creating a login for your database:
     >>The following step can be ignored as the new owner doesn't need to be mapped to the    db_owner role.
         : Select/Check db_owner in the bottom list �??Database role membership for: �??


The following steps can be subsequently performed to grant edit privileges on the feature class(es)/feature dataset(s) to the new user.

a. Connect to the database from ArcCatalog as the feature class owner.
The following links provide information on setting up either a direct connection or 3-tier connection to the database.

Adding a direct connection to a SQL Server geodatabase
============================================
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Creating_spatial_database_connections&...

An overview of ArcSDE geodatabase connections
=====================================
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=An_overview_of_ArcSDE_geodatabase_conn...

Properties of a direct connection to an ArcSDE geodatabase
============================================
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Properties_of_a_direct_connection_to_a...


b. The following link can be used in granting edit permissions on the dataset (feature class, feature dataset or table) to the new user.

=====
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=2336&pid=2327&topicname=Granting_and_revoking...
======

>> Review the "On datasets in geodatabases accessed through a database connection" section.

c. The new user can then make a connection to the database and edit the dataset from ArcMap.

Thanks

[MartinAshmore]

Many Thanks mrdei, I'll give it a try on Monday.