Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-07-11 : 10:26:02
|
| I set up new login CPTravel Security LoginCPTravel Database Datawarehouse (Setup up new cptravel login)DatabaseDatawarehouseRole CPTravel Role (new and added cptravel)Added user CPTravelview select vw_view1Some said do not name your roles as the user login.What are the recommendations on naming roles and best praticesFirst time in using the roles.ThanksIm trying to get rid of logins but use LOGINGROUPS so i have all TRAVEL tables in main ERP systemAny advice |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-07-11 : 10:27:56
|
| Of course it's up to you, but it seems to me as though it's harder to manage something where different entities have the same name.-------Moo. :) |
 |
|
|
|
|
|
SQL Roles