DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Wed Mar 20, 2019 8:40 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi, all.

We have been doing tests on the Drill Down Role, but it does not seem to matter whether it is on or off: the user is always able to drill down. For instance, in column analysis, when we look at Frequency Distribution, Viewing Details on a column displays the entire record.

What does turning on or turning off Drill Down User mean?

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 520
Location: Melbourne
Points: 3871

Post Posted: Wed Apr 03, 2019 3:17 pm Reply with quote    Back to top    

Dumb question I'm sure, but you selected "Enable drill down security" in the Details tab of the Project Properties?

Drill Down Role is project-specific and IIRC the role is ignored (ie granted by default) if you don't have that property set.
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Sun Apr 07, 2019 10:55 pm Reply with quote    Back to top    

Thanks, Stuart.

From our tests, granting/not granting the Drill Down User role and turning Enable Drill Down Security box on or off do not seem to make a difference. The user is always able to drill down. So we're at a loss as to what these settings do.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54501
Location: Sydney, Australia
Points: 295558

Post Posted: Wed Apr 10, 2019 10:06 am Reply with quote    Back to top    

Can you try this test with a user that does not have IA Data Administrator role?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 137
Location: San Antonio
Points: 913

Post Posted: Mon Apr 15, 2019 2:16 am Reply with quote    Back to top    

Yes, thanks, I'll update when we've done the test.

_________________
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours