Filtering windows users
wayde
Posts: 3
Hi
Is there a way to filter out windows user roles from being created? For instance, I generate the difference report, and under roles I get:
EXEC sp_addrolemember N'db_datareader', N'ReportUser'
GO
EXEC sp_addrolemember N'db_datareader', N'WindowsDomain\cxb'
GO
Is there a way that I could filter out "windowsdomain" users from being generated? As I am only interested in finding out which SQL roles are missing.
Is there a way to filter out windows user roles from being created? For instance, I generate the difference report, and under roles I get:
EXEC sp_addrolemember N'db_datareader', N'ReportUser'
GO
EXEC sp_addrolemember N'db_datareader', N'WindowsDomain\cxb'
GO
Is there a way that I could filter out "windowsdomain" users from being generated? As I am only interested in finding out which SQL roles are missing.
Comments
Unfortunately this isn't possible in the current version. I think the only workaround would be to edit the script and manually remove the commands for windows users.
I've logged a feature request for this, so hopefully it will be considered for a future version. The feature tracking code is SC-4474.
Simon C
So currently I see the following:
EXEC sp_addrolemember N'db_datareader', N'ReportUser'
GO
EXEC sp_addrolemember N'db_datareader', N'WindowsDomain\cxb'
GO
Where I would like just the following:
EXEC sp_addrolemember N'db_datareader', N'ReportUser'
GO
So it would need to be able to filter out roles that contain "WindowsDomain"
Kind regards,
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software