BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

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


 
Search this topic... | Search Web Intelligence 1.x/2.x Servers... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> Web Intelligence 1.x/2.x Servers  Previous TopicPrint TopicNext Topic
Author Message
cluis92
Forum Member
Forum Member



Joined: 09 Jun 2006

Posts: 8



PostPosted: Wed Oct 03, 2007 12:26 pm 
Post subject: WEBI 2.7 : how to get the List of webi's users (create doc)

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.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19319
Location: Bratislava


flag
PostPosted: Fri Oct 05, 2007 5:47 pm 
Post subject: Re: WEBI 2.7 : how to get the List of webi's users (create d

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:


Code:
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.gif

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
cluis92
Forum Member
Forum Member



Joined: 09 Jun 2006

Posts: 8



PostPosted: Wed Oct 10, 2007 5:46 am 
Post subject: Re: WEBI 2.7 : how to get the List of webi's users (create d

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.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> Web Intelligence 1.x/2.x Servers  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0272 seconds using 17 queries. (SQL 0.0026 Parse 0.0008 Other 0.0237)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo