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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 User Mapping

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
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2014-11-27 : 20:49:28
Thanks
Go to Top of Page
   

- Advertisement -