Versuch bitte mal folgendes SQL, welches ca. 863 Zeilen liefert.
Use Reportserver_neu
go
WITH perms_cte(principal_name,principal_id,
principal_type_desc,class_desc, [object_name], permission_name,
permission_state_desc, login ) as
(
select USER_NAME(p.grantee_principal_id) AS principal_name,
dp.principal_id,
dp.type_desc AS principal_type_desc,
p.class_desc,
OBJECT_SCHEMA_NAME(p.major_id) +'.'+OBJECT_NAME(p.major_id)
AS [object_name],
p.permission_name,
p.state_desc AS permission_state_desc,
sp.name as login
from sys.database_permissions p
left JOIN sys.database_principals dp on p.grantee_principal_id =
dp.principal_id
left Join sys.server_principals sp on dp.sid = sp.sid
)
-- users
SELECT p.principal_name, p.principal_type_desc, login, p.class_desc,
p.[object_name], p.permission_name,
p.permission_state_desc, cast('<explizites>' as sysname) as role_name
FROM perms_cte p
UNION
-- role members
SELECT rm.member_principal_name, rm.principal_type_desc, rm.login,
p.class_desc, p.[object_name], p.permission_name,
coalesce(p.permission_state_desc, '<mitglied>'), rm.role_name
FROM perms_cte p
right outer JOIN (
select role_principal_id, dp.type_desc as principal_type_desc,
member_principal_id,user_name(member_principal_id) as member_principal_name,
user_name(role_principal_id) as role_name, sp.name as login
from sys.database_role_members rm
INNER JOIN sys.database_principals dp ON rm.member_principal_id =
dp.principal_id
left Join sys.server_principals sp on dp.sid = sp.sid
) rm
ON rm.role_principal_id = p.principal_id
order by 2, 1, 4, 5, 6, 8
Findest Du dort auch den principal_name NT AUTHORITY\LOCAL SYSTEM oder NT AUTHORITY\NETWORK SERVICE wieder?
Bei mir läuft es in der Regel unter NT AUTHORITY\NETWORK SERVICE.
Siehst Du hier eine Session?
exec sp_who 'NT AUTHORITY\LOCAL SYSTEM';
Einen schönen Tag noch,
Christoph
--
Microsoft SQL Server MVP
www.insidesql.org/blogs/cmu
Report Server Windows Service (MSSQLSERVER) kann nicht mit der Berichtsserver-Datenbank verbunden werden.
