[dba-SQLServer] Setting permissions on databases

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
> 
> 



More information about the dba-SQLServer mailing list