jwcolby
jwcolby at colbyconsulting.com
Mon May 25 14:41:45 CDT 2009
That did it, thanks. John W. Colby www.ColbyConsulting.com Doris Manning wrote: > 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 > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >