Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 239 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE 12C. Users have lost access rights to their personal folders
Hi there
We have an OBIEE 12.2.1.4 cluster with two instances, and the bidata folder is located on shared storage.
Authentication is configured via the repository (RPD) using an initialization block with an Oracle DB query similar to:select username, name, role from app_users where username=:USER and password=:PASSWORD and...
In other words, users are not physically created anywhere (in WebLogic or AD), with rare exceptions for maintenance accounts; their identities and roles are stored in database tables.
Upon the first authentication, BI automatically creates a folder in the catalog with the username and grants the appropriate permissions to it.
During virtual machine maintenance (I am not entirely sure of the details, but the machines were joined and disjoined from the Active Directory), some users lost access permissions to their own personal folders.The attached screenshots show two cases: before and after the issue. In the first case, permissions are granted to the specific owner, while in the second, only standard permissions remain, including the BIUser role we manually created.
We are not currently considering restoring the catalog from backup (althoug
h we do have one).
All users are assigned the BIUser role.We can grant full privileges to these folders using scripts like the following:
runcat.cmd -cmd setItemPermissions -online "http://192.168.10.10:9502/analytics/saw.dll" -credentials "C:\temp\weblogic\creds.txt" -setOption changeMentioned -changeOption replace -accountName "BIUser" -accountType approle -permission F -item "/users/meinzergd" -recursive true
However, is there a way to specify the actual username so that BI simply applies it to the ACL without validating it against the internal security store?
Answers
-
I would advise to closely work with Oracle Support and see if they can share this case with Product Team to get the correct guidance.
0 -
Yep, you need to get onto Oracle support to get this resolved
0 -
New Symptom: Additionally, we discovered that user provisioning is failing. When a new user logs in (authenticated via DB table), their personal folder is not automatically created under
/users.Consequently, the user does not see the "My Folders" section in the Catalog, only "Shared Folders".0



