how to grant user in a sqlserver datbase

[Bleek]

I have created a sqlserver database for EA to use.
I created the tables as a user with create rights, but I want other users to be able to write to those tables.

what grants do I need to give?
Do I need to create a role?
Why is there no script from sparx for this ?

[qwerty]

Well, if they shall write then grant them the right. Where is the problem? DB management is task of the DBA, not of the software utilizing it.

q.

[Sunshine]

If you are having trouble setting up a SQL database then suggest seeking help from a SQL DBA or go to the MS website as there is a lot of help there on the subject. Sorry but its too technical to explain to a novice on this forum. You need to understand about  the workings of the DBMS and security models such as impersonation, trusted subsystem, single sign on etc. Most places I've worked seem to set up the database with trusted subsystem. i.e. use a username and password to access the database and that is used in the connection string. Once that's done you enable security in Sparx EA Model and create user names and passwords for each user giving them the various access rights to model.
However the you can use single sign on which passes the security token from the windows logon. Again you still need to enable security in Sparx EA model and add the users using the active directory (assuming thats being used) user names and access rights to the model.
Hope that helps  

[skiwi]

There is a script

Please see http://www.sparxsystems.com/enterprise_architect_user_guide/10/projects_and_teams/createanewsqlserverreposi.html\

[Sunshine]

There is a script

Please see http://www.sparxsystems.com/enterprise_architect_user_guide/10/projects_and_teams/createanewsqlserverreposi.html\

Think he's used that to create the tables but setting up user rights seems to be his downfall.