[dba-SQLServer] Setting permissions on databases

Doris Manning mikedorism at verizon.net
Mon May 25 13:00:53 CDT 2009

In SQL Server 2005, you add new Logins through "Security / Logins".  This
allows you to control the databases those logins may access.  

In the Database itself, expand Security and then Roles.  You would set your
groups up under Application Roles and give those roles appropriate
permission to access database objects.  Then you assign your users/logins to
their application role groups.

SQL Server 2008 will hopefully be very similar.

Doris Manning

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, May 25, 2009 1:47 PM
To: Dba-Sqlserver
Subject: [dba-SQLServer] Setting permissions on databases

I have done all of my work on SQL Server on my own servers with only myself
as a user.  I now have to set permissions to databases for other groups, at
least I think they are groups.

At the client, SQL Server 2008.  I can see the permissions in the database
properties in dialog for the databases.  One db that has three groups
(although it says "Type" is user), but my newly created database only has
one (my user).

I need to set my new database to give permissions to the same groups (or
users) as the existing database has.  I try to right click on the box that
displays users for the database / properties / permissions but there is no
way to add it there.  Do I add new users / groups in Management Studio
somewhere or do I have to go elsewhere?


John W. Colby
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list