So i am Brand new in this area i have developed reports before and deployed them but never got an oppurtunity to work on security and who gets to see what.. Purpose of the view is thats what im thinking..
We have a reports database has 100 reports . What we are trying to do is have a faster way to manage report subscriptions. The tables i have is Analysts, SalesRep,SalesRepSubs and dbo.users.Dbo users are our web portal users where they can view reports.
I want to create a table in which every report is viewed per security level. We have 6 layers of security layer 1 is lowers to layer 6 being highest.
This is the relationship between tables
Salesrep_sub (SRID_SUBID PK)
Analysts : (AnalystIDPK)
Users: The Table has all Users who are Salesrep,Sales Repsub and Analysts)(PKID PK) and we have cols SRID, SRID_SUBID & AnalystID) in this table.
Alter View dbo.User_Access
u.SecurityLevel,a.AnalystID from dbo.Users u
join tbl_Analyst a on a.AnalystID=u.UserID
join tbl_SalesRep s on s.SRID=u.SRID
Join tbl_SalesRep_Sub sr on sr.SRID_SubID=u.SRID_SubID
My question is what do i do next? Add this view to Report server? or how can i make it functionl?????????FM
View Complete Post