I have a query above gives the report name on all servers along with other data. Im interested in Giving Access to users based on Security level.
Alter View dbo.User_Access AS
select S.SR_name,u.SRID,sr.SRsub_name,u.SRID_SubID,U.Userid,u.username,u.Email,u.SecurityLevel,a.AnalystID from dbo.Users uleft join tbl_Analyst a on a.AnalystID=u.UserIDleft join tbl_SalesRep s on s.SRID=u.SRIDleft Join tbl_SalesRep_Sub sr on sr.SRID_SubID=u.SRID_SubID
The View has all the lists of users with security levels...
My Question is there a way based on security levels... Some reports are sent via email and some are stored where a user can access it.
Any ideas ? Any suggestions?
View Complete Post