HI! I need some help with permission to view . I have 10 accounts. everybody can look in report trough rheir own rights (Users acaunts - computers , admin - other interface , etc) in standart report.
1)When I write.than everobody user's can look all objects my report in Advanced SQL -
SELECT
Nodes.NodeID AS NodeID,
Events.EventTime AS Event_Time,
--Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
( STR(Events.EventType) + '.gif') AS EventTypeIcon,
Events.Message AS Message
FROM Nodes
INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes
ON (Events.EventType = Events_EventTypes.EventType))
ON (Nodes.NodeID = Events.NetworkNode)
where
(NOT ( DATEPART (weekday, EventTime) in (7,1)))
AND NOT (Convert(Char,EventTime,108) <= '09:00') --<--- NOT before 06:00
AND NOT (Convert(Char,EventTime,108) >= '20:00') --<----- NOT after 21:59
AND [EventTime] > convert(nvarchar(10),getdate()-5,120)
AND [EventTime] < convert(nvarchar(10),getdate(),120)
AND (Events.EventType ) in (1,5)
2) why I have only right write in Advanced SQL.
Help me?!
