WEBI 2.7 : how to get the List of webi's users (create doc)

server administration Web Intelligence 1.x/2.x Servers
1

Hi,

is it possible to get the list of webi’s user with the privilege to create document in the repository?

BO 5.1.7
WEBi 2.7.

Best regard.

cluis92 (BOB member since 2006-06-09)

2

I haven’t been using BO 5.1 for years so I am not 100% sure of this but try it anyway.

Run the following SQL against the BO repository tables:

select act.m_actor_c_name as BO_username
  from obj_m_actor act,
       obj_m_actorlink alink,
       obj_m_reslink rlink
 where act.m_actor_n_id = alink.m_actl_n_actorid  
   and alink.m_actl_n_id = rlink.m_res_n_actlinkid
   and rlink.m_res_n_restype = 7  /* security command */
   and rlink.m_res_n_resid = 202  /* "Create documents in WebI" property */
   and rlink.m_res_n_status = 1   /* enabled */

As I said, I dont use 5.1 so I cant verify the results because it looks to me that the security command IDs are different in BO 6.5 that I use now.

So check the result of the above SQL with the real command restrictions set in Supervisor. :yesnod:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi,

thank you for the solution. I try it in our repository and i can get the list of webi’s users.

I check it and the result is OK.

Thanks a lot.

Best regards.

cluis92 (BOB member since 2006-06-09)