security - Significance of SSRS roles? Reports depending on permission of Stored procs -


i have set of ssrs reports using stored procedures , want give view-only access of reports someone. believed done assigning users/groups "browser" ssrs role. not working.

the grant/deny of reports access done grant/deny of execute permission on underlying stored procs.

am missing here? if above true, significance of ssrs roles.

data source permissions different report access permissions.

ssrs roles control whether user can access report. report data source set pass user credentials database , hence stored procedures; why you're needing set permissions @ level, too.

if user had no access reports not able run them , no database access occur.

to @ different way, consider report credentials stored @ data source , not passed through using windows authentication. means user running report connect database stored credentials, not themselves. need worry database permissions data source credentials. still need able grant/deny access report, , report access permissions make difference.

edit after comment:

you've mentioned 2 scenarios, 1 data source set store database user credentials, , other data source database access set use credentials of whomever running report.

in both scenarios control access report @ report server level.

so, if grant domain\user1 browser role directly @ report level or higher, can access report. no access set up, domain\user2 cannot run report.

now report permission set need consider how data source set up.

when credentials stored @ data source, need consider database permissions user. have set data source connect database domain\reportuser - user need access underlying stored procedures. domain\user1 not access database not need execute on these objects; domain\reportuser does.

when credentials not stored, data source database access performed user running report, in case when domain\user1 runs report, running underlying stored procedures need execute privilege on objects.

in both data source scenarios, domain\user2 cannot access report because of report permissions database permissions don't matter.


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more