Set up permissions for developers

Hi all

I've got a question I'm sure has been asked somewhere before but I can
not find it. If there is an existing link somewhere just point me in
the right direction. Otherwise any help would be appreciated.

We have a couple of different levels of people that have need to
access our SQL Server 2000 instance. What I would like to do is set up
a Developer role and give everyone in that role read - write access to
a specific set of databases on the server. In addition they would need
to be able to create new DBs. I see that I can add a new role with
sp_AddRole, but from what I can see and have read it has to be done
once for each database. I'd like to create the role, set the
permissions on it and just add the users to it. Or is there a better
way to do this?

thanks in advance

.

Relevant Pages

  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)
  • Re: Permission to restore databases and access them without being
    ... dbcreator to the login so that you can restore the databases. ... " in SQL Server 2005 Books Online: ... assign your wanted permissions such as db_reader/db_writer ...
    (microsoft.public.sqlserver.security)
  • Re: Hiding database
    ... Jasper Smith (SQL Server MVP) ... >>>Can someone explan how to hide databases in enterprise manager. ... >> permissions are granted to these users. ... > have access rights to one of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: public role???
    ... What exactly do you mean by "new users have access to all DBs"? ... If you mean that new users can see the names of the other databases, ... Documentation on the "guest" account is available in the SQL Server Books ... > permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Security Script
    ... You when you restore a database, or attach it, SQL Server maintains the ... logins but removes all permissions to databases and their objects. ...
    (microsoft.public.sqlserver.security)