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


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)

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)


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)