Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] User Level Access for Live Reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] User Level Access for Live Reports
 Login/Join
 
Arif
Guru
posted
Is it possible to to provide user access to their informat only form Live database:
For example
I have 5 car stores,
Detroit, Chicago,NY, LA, & London

I want Chicago Manager to only access Chicago data and parametscreen only show models that are available in Chicago. NY should see NY, LA should see LA.
I know there is got to be a way to pass user ID to the system to show only user related data to user.
Also, when I want to publish graph on dashboard, user should only see data realted to their store.
I know I could do access list bursting for library reports, but can I do same sort of security for live database?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Severus.snape
Platinum Member
posted Hide Post
Hi,

You could do this using DBA restriction at the Master File level.
Lookup for information on DBA file ..

thanks
Sashanka


WF 7.7.03/Windows/HTML,PDF,EXL
POC/local Dev Studio 7.7.03 & 7.6.11
 
Posts: 103 | Registered: June 12, 2009Report This Post
njsden
Virtuoso
posted Hide Post
Is there something you can implement in your database platform directly? For instance, Oracle allows for the creation of Virtual Private Databases which provide access to certain domains of information on a user/role level. That way, your users can only access what they're allowed to, even if they use tools other than your WebFOCUS environment (such as accessing the database from Excel).

It's just a thought, of course. It all depends on your infrastructure and security policies your company can (or is willing to) implement.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Waz
Expert
posted Hide Post
The DBA options is probably the best, you will have to set a DBA password for each user type.

I assume that you have the id of who is running the reports ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] User Level Access for Live Reports

Copyright © 1996-2020 Information Builders