nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

User folder/Saved Queries

Charles M

Hi All,

Is there a way to access the folder/objects of a user that is no longer in the system (e.g. removed from the WLS LDAP)? The intent is to access some saved queries, and copy them to a shared location for others to use.

OBIEE 11.1.1.9..x | OBIA 11.1.1.10.1

Regards,

Charles

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Did you try using Catalog Manager? You must manage to do it using that tool (not from the web frontend of OBIEE, there you will not be able to do it).

Charles M

Hi Gianni. Thanks. I did open up the Catalog Manager (as WebLogic) in online mode, but I get 'No Access' when I try to open the folder.

Gianni Ceresa

I don't have an OBIEE running now, did you try changing the permissions on the folder to grant you access? Otherwise offline.

Charles M

Hi Gianni,

It doesn't look like I'm able to modify the permissions in the Catalog Manager GUI (online). I will try to use the offline mode (server-side).

Regards,

Charles

Gianni Ceresa

Of course you can always copy things in the filesystem (remember to take the .atr file too as without OBIEE will even not see the object at all), but you will still need to reset permissions on it (which are inside the .atr in binary and the catalog manager is the tool able to play with that).

Charles M

Ok, thanks Gianni. Would it be possible to "re-create" the account (in WebLogic) with the same ID? Thus, allowing access back to the user objects?

Gianni Ceresa

As you are on OBIEE 11g (11.1.1.9) there are GUID between your accounts and OBIEE. Each account had a unique GUID and OBIEE uses the GUID to reference things. So even creating the same name in the weblogic embedded LDAP your new account will get the a new GUID and will be treated as a totally different account than the old deleted one.

[Deleted User]

Gianni gave already gave you all the important bits & pieces.

It's the 11g family, so you'll have the GUID problem if you simply "recreate" the user. Personally in this kind of case I simply go down to file system level and grab what I need. Much less painful.

Charles M

Thanks Christian. I just tried this out in a non-prod instance, but it didn't seem to work.

Here's what I did:

Copied the {id}.atr and the corresponding {id} directory from 'users' to 'shared'; then bounced the application.

I don't see it in the front-end catalog, under shared folders ... but, I do see it there in the catalog manager. Did I miss something?

Regards,

Charles

Charles M

Update: I can see it, using "admin view" from the catalog/front-ent. But, I still access denied when I click on it.

When I check the ownership, it says System Account. Could I change that?

Charles