John W. Colby
jwcolby at colbyconsulting.com
Mon Oct 11 15:32:18 CDT 2004
Yea, I don't need any of that stuff. I am the only user. I just need all the Servers to recognize that user. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ At least for the time being, you only need 1 user, which you already have -- sa. Once you finally get around to adding users I STRONGLY recommend that you use roles rather than just users. That way you can define a role once, and then add all the users you want to it. Change the roles of the role and all users inherit the change. You can also build roles up. I often go this route. I.e. Role -- sales staff:: no table rights. Rights to various procedures that allow update, insert, delete maybe. Role -- Manager: no table rights. Rights to do anything Sales can do, plus run some reports and view salaries. Role -- Developer:: rights to tables, sprocs, views, etc. Now add JWC to Sales and also to Manager. Everyone else in Sales gets only those rights, but JWC gets Manager rights as well. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com