BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Security Table


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
lucy.online
Principal Member
Principal Member



Joined: 03 Apr 2012
ASUG Icon
Posts: 229


flag
PostPosted: Wed Mar 20, 2013 3:52 pm 
Post subject: Security Table

Has anyone created /designed a security table. I just wanted to get an idea about how to go about it. ??
_________________
"Knowledge is knowing that a tomato is a fruit, but Wisdom is knowing not to put it in a fruit salad."
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17346
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Wed Mar 20, 2013 4:56 pm 
Post subject: Re: Security Table

Come on Lucy, did you at least try a search?

I've found:
- Here on B icon_mrgreen.gif B's Download section you can find Steve Krandel's presentation Using Designer to Implement Row-Level Security to get you started.
- http://www.forumtopics.com/busobj/viewtopic.php?p=425660#425660
- http://www.forumtopics.com/busobj/viewtopic.php?p=688714#688714
- http://www.forumtopics.com/busobj/viewtopic.php?t=42178&highlight=security+table
- http://www.forumtopics.com/busobj/viewtopic.php?p=172869#172869

And my recommendation (Oracle VPD e.g.) http://www.forumtopics.com/busobj/viewtopic.php?p=925124#925124

_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
lucy.online
Principal Member
Principal Member



Joined: 03 Apr 2012
ASUG Icon
Posts: 229


flag
PostPosted: Thu Mar 21, 2013 6:26 am 
Post subject: Re: Security Table

What i want is to Limit the customers to see the data pertaining to their own portfolio..
_________________
"Knowledge is knowing that a tomato is a fruit, but Wisdom is knowing not to put it in a fruit salad."
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 13981
Location: London


flag
PostPosted: Thu Mar 21, 2013 7:22 am 
Post subject: Re: Security Table

lucy.online wrote:
What i want is to Limit the customers to see the data pertaining to their own portfolio..


Did you read through the links?
icon_confused.gif

_________________
Next Available for Contract Work - January 2018

Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
lucy.online
Principal Member
Principal Member



Joined: 03 Apr 2012
ASUG Icon
Posts: 229


flag
PostPosted: Thu Mar 21, 2013 8:28 am 
Post subject: Re: Security Table

im doing it now.....
_________________
"Knowledge is knowing that a tomato is a fruit, but Wisdom is knowing not to put it in a fruit salad."
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19351
Location: Bratislava


flag
PostPosted: Thu Mar 21, 2013 9:41 am 
Post subject: Re: Security Table

cool icon_smile.gif
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
AFAF
Principal Member
Principal Member



Joined: 12 Jul 2012
ASUG Icon
Posts: 128


flag
PostPosted: Fri Mar 22, 2013 8:46 am 
Post subject: Re: Security Table

Say the reports are based on Location. By this I mean NY guy should see data for NY and CA guy should see the data for CA only.

Below is one way of designing the row level security.

Create a security table in the database which contains Locations and UserID's. How to populate this security table is another story.

Once you have Users and their location, create a global filter in the Universe with the below logic;

There must be another location in your schema which can be used to filter the locations for the report...

Schema.Location =
(SELECT
SECURITY.LOCATION
FROM
SECURITY.TABLE
WHERE
SECURITY.LOCATION=@VARIABLE('BOUSER')

This filter will be enforced for all the queries hitting this Universe with a filter on Location...

when the query comes to this filter , it will execute the sub-query of this location filter first and pass the location of the User to the filter.

Getting my point?

_________________
Thanks & regards,
AFAF.
-------------------------------------------
One who asks a question is only a fool for five minutes; one who does not ask a question remains a fool forever.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0297 seconds using 18 queries. (SQL 0.0029 Parse 0.0009 Other 0.0259)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo