Activity overview
Latest activity by jchow
Hi Brian,
Let's say I am fully on role-based permission but at some point I would need to add new NT Groups and grant role permissions to this new NT Groups.
Here is an example of the hierarchy:
MyDomain/AllUsers (NT Group) - contains -> MyDomain/MyNewGroup - contains -> Some users
I want to add MyDomain/MyNewGroup into the role db_owner but I do not want to add this Group as a Login on the server level.
I do not need SqlCompare to check for group affinity but I want sqlcompre to not doing anything on the server level, i.e. SqlCompare is totally free to create login on the Database level or anything else but not attempting to Create Login on the DB Server itself as the runner for sqlcompare synchronization script is a dbo but not an sa.
As the deployer, I would be responsible for the Logical breakage if that new group cannot login for any reason, but I do not want the upgrade to fail at the spot with a sql error because the runner of the synchronization script do not have permission to create login on the server level. / comments
Hi Brian,
Let's say I am fully on role-based permission but at some point I would need to add new NT Groups and grant role permissions to this new NT Groups.
Here is an example of the hierarchy:
My...
Hi Brian,
As mentioned in the original post.
My server and database is permissionging user login with an NT group
i.e.
I have an NT group called [MyDomain\Users] in both the server and database users list. This NT group contains everybody in MyDomain -> everybody in MyDomain can log into the server and database / comments
Hi Brian,
As mentioned in the original post.
My server and database is permissionging user login with an NT group
i.e.
I have an NT group called [MyDomain\Users] in both the server and database use...
Hi Brian,
It does not seem like ignore permission or ignore rolemember would serve my purpose because they would entirely ignore any permission change that I would wanted.
For as much as I wanted based on my use case, I DO want sql-compare to generate sync script to add role member or to grant my DB objects the permission I wanted using sync script.
The part that I am churning over on is the login creation which is unnecessary when I am permissioning using integrated windows authentication and NT groups.
To put it in short, I just want SQL-compare to stop generating those CREATE LOGIN statements. / comments
Hi Brian,
It does not seem like ignore permission or ignore rolemember would serve my purpose because they would entirely ignore any permission change that I would wanted.
For as much as I wanted b...
Not generating sync scripts that does server level changes?
Hi,
I want to know if there is any options/param that I can pass to SQL Compare so that it wouldn't generate a sync script that attempts to make server level changes?
Here is a detail description o...