Who's Online Now
0 registered members (), 7 guests, and 7 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Ravi Pasapula, kumar1900, B_DOYLE, rdeshab, samba
1296 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
495,787 PAYE RTI
60,739 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#5915 - 19/10/10 08:23 AM Using Security with Discoverer  
Joined: Aug 2010
Posts: 6
NDW Offline
NDW  Offline

Joined: Aug 2010
Posts: 6

I am in the process of creating a Business Area to satisfy a series of reports all around HR. I want to ensure that the inherrant security is maintained in what I create... My question is, what views etc do I need to look at? Should I refer to the ones in the forms themselves?


#5916 - 19/10/10 08:26 AM Re: Using Security with Discoverer [Re: NDW]  
Joined: Sep 2005
Posts: 41
AlexChard Offline
AlexChard  Offline

Joined: Sep 2005
Posts: 41
Leamington Spa
Assuming you're using seeded HR security of some sort, using any of the secured views (per_people_f, per_assignments_f, etc) will maintain your security.

I avoid using the forms views as they're built for the forms and can change unexpectdly.

Oracle EBS Contractor
#5932 - 21/10/10 08:35 AM Re: Using Security with Discoverer [Re: AlexChard]  
Joined: Oct 2010
Posts: 1
Ebo Offline
passing stranger
Ebo  Offline
passing stranger

Joined: Oct 2010
Posts: 1
I've used custom views for this recently - we used base tables and secured the data in the views using seeded security functions: Hr_General.get_business_group_id to make sure we get data for the right business group and use the hr_security package view_all and show_person functions (both return 'TRUE' or 'FALSE') to make sure the data is available to the current responsibility.

Moderated by  Administrator, bcooper, CT 

Forum Statistics
Most Online283
Dec 25th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,117
delboy 1,308
bcooper 1,293
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.022s Queries: 15 (0.005s) Memory: 2.7450 MB (Peak: 2.8888 MB) Zlib disabled. Server Time: 2020-07-08 22:22:42 UTC