Is it possible to use the repository tables to get a list of users with row level restrictions and the text of the restriction?
Cindy Clayton - Business Objects Consultant AT&T
336.698.2144
Give people more than they expect and do it cheerfully. Talk slowly but think quickly.
Smile when picking up the phone. The caller will hear it in your voice. Mind your own business.
Learn the rules then break some.
Judge your success by what you had to give up in order to get it.
In a message dated 00-03-10 12:37:06 EST, you write:
Is it possible to use the repository tables to get a list of users with row
level restrictions and the text of the restriction?
Cindy Clayton
Yes.
Oh, you want more? You have to look in the repository tables (naturally). I have not yet taken the time to fully reverse-engineer the contents, but the table in question is OBJ_M_UNIVDBCST.
If you recall, there are three types of restrictions that you can set up in Supervisor. You can restrict objects, rows (by where clause), and tables (by table mapping). According to the documentation on the repository HTML, these are all stored in the OBJ_M_UNIVDBCST table. There is a column in this table that contains the type of the restriction, and other columns that will contain supporting information for the restriction (i.e. the SQL text of a where clause).
As I said, I have not written any SQL code against this table that I can share. But perhaps this gives you a starting point to look at.