oracle11g - Visual Studio, SSRS, Oracle sys_context('USERENV', 'OS_USER') -
i using visual studio 2012, oracle 11g , ssrs 2012. i have developed report checks session userid determine if can view report or not against table stored in oracle db. everything works correctly in preview mode visual studio 2012; however, when report deployed ssrs 2012 data not returned, , expected if us. select comp_flag, mbr_mmis_idntfr, last_name, first_name, middle_name, org_code, org_name, org_phone, last_verified_date, rac_start,rac_end, rac_code tpl_chip_mv (comp_flag <> 'n') , (1 =(select count(user_id) expr1 report_auth (user_id = concat('hlan\',upper (sys_context'userenv', 'os_user')))))) why work correctly in visual studio 2012 preview mode , not in ssrs 2012? can work in ssrs? the problem os_user different. when you're running locally in preview mode, account running visual studio own personal account. os_user database sees personal operating system user. when you're deployin...