Row Level Security in Business Objects by Creating a Data Security Profile
ฝัง
- เผยแพร่เมื่อ 21 ต.ค. 2024
- Implementing Row level security in SAP Business Objects 4 using the Security Editor and creating a Data Security Profile from the Information Design Tool.
You might also be intrested in Applying Row Level Security using a Security table .... • Row Level Security In ...
Regards,
Naresh
![CAMPปลิ้น | EP.83[1/2] เปิดแคมป์หลอนต้อนรับ 2 ตัวพ่อแห่งวงการผี!](http://i.ytimg.com/vi/2uPuHYHgwiI/mqdefault.jpg)
One of the finest video I have ever found on youtube , thanks Naresh.
Thank You Preetam for taking the time to let me know ! Glad that it helped.
Very clear and consise tutorial. Thank you Naresh.
Thanks Naresh ...very well explained.
I have learnt something from you today.
Hi Naresh, thanks for all the BO videos. I also wanted to check if this Firepass sap network you use is a cloud based instance, that I can get from SAP, because I wanted a sandbox type instance of BO at home with all the client tools where I could practice. Thanks.
unfortunately no, your best bet is to spin up a google or azure server on the cloud and install BOBJ .
th-cam.com/video/KUMvAdB831s/w-d-xo.html th-cam.com/video/AOxh-j6V76M/w-d-xo.html
The client tools can be installed on your local machine.
Hope that helps !!
Hi Naresh...this was very useful to understand row level security...thank you so much....Hope to see some more useful topics like traps in universe...
Glad that you liked it and Thank You for taking the time to leave your comments !
Regards,
Naresh
That's great Naresh. One more request. Can you also post some videos on applying object level and report level security. Thanks.
Hello Satish,
The one that I have done a demo on here is talking of security application when you are going against a relational database. In your case I am assuming you are going against a cube or is it a bex or so directly ? The same may not apply in ur case and I would think (as you said already) that the security should carry over. But would not be sure as I have not tried that out. Would be great if you could let me know what you find out.
Thanks,
Naresh
Naresh did a great job with the videos but just wanted to giv you one feedback. Some videos its difficult to follow where your pointer or the focus is because it doesnt show the mouse pointer .... Its becoming difficult to follow wer ur clicking and whats happening .... Thanks.
Hi Naresh, Great video. Guess I am commenting so late as this is posted few years ago still hoping to be answered. *Why at all do we need data security profile options (AND, OR, ANDOR)? *What purpose does these Business security profile options solve ?*During the video where did this SQL editor got opened. Can we see the query generated in our data security? If yes then where?Thanks and Regards,Alankar
Very nice. Good examples!
i'm assuming this holds true only in a relational / OLTP environment, correct? It wouldn't be possible to implement this with OLAP universe built from infocube/multiprovider.
Please let me know if i'm wrong...
Hi Naresh. Thank you for the valuable information. I succeeded to create and implement security profiles according to your instructions. I still have one question: if you don't add a user to any of the user groups referred to the security profiles, the user still is enabled to see all the data. Is there a way to deny all the data per default unless the user belongs to one or more user groups above?
+Paulo Gottlib glad that it helped. you are now talking of user level information -:) so would have to be based on each user. Though in this too you could create one group where you by default add all users until they are added to one of the security groups. that one group by default would have full restriction and users would not see any data. But to answer your question, this will not do it by default. I believe there are no other options (pardon me if I am not remembering well as I am not actively using Business Objects any more)
You are right, for them I beleive you would have to set it up the security on the BW side of the implementation.
Thanks for the feedback TeeCeezz. For the videos that have the mouse pointer missing I am trying to put in TH-cam annotations showing where the mousing is being clicked, not for every step but for the ones that may not be obvious.
These are the older videos and the newer ones will have the mouse pointer showing up properly.
Regards,
Naresh
Hi Naresh..Thanks for the Video it is very clear.. I have one doubt.. Already we r created security in SAP BI side using RSECADMIN Transaction.. These security will carry over to BI?? Or we need to create security in Universe level again?? Pls let me know..
Thanks,
Regards,
Sathish Kumar.N
Hello Bhaskar,
Not sure if I understand your question.
Can you provide more details, if its something quick I can let you know my thoughts.
Also, it involves more details I also recommend putting your question up on SCN or BOB (if you have not done so already).
Regards,
Naresh
Hi Naresh, I did the same thing but it took hours to reflect the filter in my report. where should i refresh this?
Hi Naresh,Thank you fr video,I have one doubt suppose if we have more users with different groups on that scenarios how to apply row level security.
Hello Venkata,
Have you checked the last couple of minutes in the demo and see if that is what you are talking of...so if you have a user with AMER and EMEA user group then you want to apply them as OR clause and not AND
Hope that helps !
Regards,
Naresh
Thank you Naresh for the reply,I got solution for that ,My requirement is exact to Row level security using security table which one you posted earlier sessions.
:) Keep Posting :)
You are welcome !
Thanks for the Security related info.
But need help to apply security based on user roles. Currently we are applying security on folder level using conditional objects,
this makes user reports worse, because it's taking long time to run report after applying this security. Here i need to refer more tables and union operator and also we are using derived table for referring user roles. But I think
there should be a better way to work on this.
Any help here please.
Thanks,
Bhaskar
Naresh,Do u have any tutorial for database ranking?
Very good...thanks
Hello Naresh,
This was very informative for me. But I have this doubt from the beginning. For Example In CMC we create a group for america region and assign the user to it. In Security editor we create a data profile for America and give the region id as 2 and mp the america region that we created in the previous step. But when we are running the query how does this region_id='2' come into picture? When a user logs in from BI Launchpad and opens that universe his id is checked in CMC to which part he belongs, but how does that condition come into query by default?
have you checked the entire video ? if I recollect it I have mentioned all the details were you create the data security profile and assign in the information design tool for the universe
Yes Naresh my doubt was how the Id s getting into the query. I understood all the steps except this
basically the security data profile is added to a user group and any user in that group wll have that secrity forced on him or her.....hope that helps
Very helpful, thank you!
Can you elaborate on your question ?
Hi Naresh,
Even i don't know thats why i asked you,
Thanks for ur reply anyways, I'll try and let u know,
Thanks& Regards,
Sathish Kumar.N
Not at the moment Indrani.
Hi Naresh, I did the same thing but it took hours to reflect the filter in my report. where should i refresh this?
Thanks for the Security related info.
But need help to apply security based on user roles. Currently we are applying security on folder level using conditional objects,
this makes user reports worse, because it's taking long time to run report after applying this security. Here i need to refer more tables and union operator and also we are using derived table for referring user roles. But I think
there should be a better way to work on this.
Any help here please.
Thanks,
Bhaskar