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? TIA, -- John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com