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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2014-11-16 : 16:22:00
|
| If I need to add the DATABASE ROLE MEMBERSHIP in the User Mapping during the Business hours, will there be any problem for any existing User ROLES and and other User Groups in the User Mapping.In other words shall I add Role during the normal hours?Thanks in advance. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-11-17 : 01:49:53
|
| We normally make changes out of hrs and test . The changes are made via scripts, with rollback scripts.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-11-17 : 17:29:38
|
| Thanks for that , having done during Business hours what would be the impact that can be / Minimised on existing userss with their ROLES Privileges?Can you please explain. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-11-18 : 01:42:10
|
| Some things to minimise impact on systems can include : scripting changes , tested on lower environments, some sort of control management.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2014-11-27 : 20:49:28
|
| Thanks |
|
|
|
|
|
|
User Mapping