Activity overview
Latest activity by wayde
Hi, thanks for the reply. No, this does not help, as I need to find the permissions and role memberships. What I would like to do though is to be able to filter out windows roles, and only see ones for SQL users.
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" / comments
Hi, thanks for the reply. No, this does not help, as I need to find the permissions and role memberships. What I would like to do though is to be able to filter out windows roles, and only see ones...
Filtering windows users
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'
G...