on 07-10-2009 8:41 PM
We're in the process of upgrading to BOE XI 3.1 and want to be able to use the row level security built in BO 6.5 in our upgraded environment, so that we don't have to put a bunch of restriction statements (WHERE clauses on tables with sub-selects) in our Universes. What is the best API interface or other methodology to use to be able to expose the BO 6.5 security tables in BOE XI 3.1?
You should be able to use Import Wizard to import Security and Row Level security into Xi3.1 from 6.5.
Please review XI3.1 Admin guide for more details on how securty is organized in Xi3.1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry...after re-reading my first post, I guess I didn't convey specifically enough on what we're trying to do...
We have created Data Integrator jobs that pull account Id and group id information from the security (OBJ_*) tables maintained by the 6.5 application. We load this data into custom built tables which we use in row level security restrictions in the Universe. With the migration to XI 3.1, will we be able to access the XI 3.1 security tables, using DI, in order to create the security tables we currently use in our restriction sets?
Edited by: Dennis Scoville on Jul 10, 2009 3:04 PM
Repository tables in XI architecture are not accessible directly, they are encrypted. Your DI jobs will not be able to pull this information anymore. I'm not too familiar with DI, but I think it can only access regular DB tables, with XI repository access is not that simple anymore.
You will need to write a custom application using Enterprise SDK to export this info or find another way of setting row level restrictions.
https://www.sdn.sap.com/irj/boc/sdklibrary has code samples and all public API's.
I had already downloaded this and was unsuccessful in finding a pertient API, mostly because searching through a ton of HTML files is cumbersome and I'd have to have a perfect search string to find what I'm looking for. I was hoping that someone may have already encountered this and has the specific API or APIs that could be used.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.