1 2 Previous Next 19 Replies Latest reply on Dec 11, 2018 9:20 PM by Charles M

    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

        • 1. Re: User folder/Saved Queries
          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).

          • 2. Re: User folder/Saved Queries
            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.

            • 3. Re: User folder/Saved Queries
              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.

              • 4. Re: User folder/Saved Queries
                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

                • 5. Re: User folder/Saved Queries
                  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).

                  • 6. Re: User folder/Saved Queries
                    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?

                    • 7. Re: User folder/Saved Queries
                      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.

                      • 8. Re: User folder/Saved Queries
                        Christian Berg

                        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.

                        • 9. Re: User folder/Saved Queries
                          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

                          • 10. Re: User folder/Saved Queries
                            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

                            • 11. Re: User folder/Saved Queries
                              Gianni Ceresa

                              Did you copy the whole <userXYZ> folder? I would only take a subfolder or content as the main user folder contains bunch of "special" things (metadata files storing things) the catalog maybe get confused about.

                              And you will still need to erase permissions to add yourself in it as by default only the deleted account will be granted any kind of access on those objects.

                              1 person found this helpful
                              • 12. Re: User folder/Saved Queries
                                Charles M

                                Hi Gianni,

                                 

                                I did copy the entire <userXYZ> folder. I'll try again with some individual objects.

                                 

                                Also, on your second point, do you know how to do that?

                                 

                                Thanks for helping ...

                                 

                                Charles

                                • 13. Re: User folder/Saved Queries
                                  Christian Berg

                                  Charles M wrote:

                                   

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

                                   

                                  Not sure what the impact of prod vs non-prod would be ;-)

                                   

                                  Charles M wrote:

                                   

                                  Also, on your second point, do you know how to do that?

                                   

                                  In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that should be it.

                                  1 person found this helpful
                                  • 14. Re: User folder/Saved Queries
                                    Gianni Ceresa

                                    Christian Berg wrote:

                                     

                                    In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that should be it.

                                    As a shortcut for this one, to not have to copy/paste content (XML) around files. Create a new object of the same type and same name. Then just copy the file over and replace it keeping the .atr your just created.

                                    The .atr file has security and object kind, so if you have an .atr matching the name of the old object you want to access that's all you need in the end, without having to really look into the files and play with XML.

                                     

                                    PS: as you can see it's not really a fun thing to do, so you maybe want to setup a process for when employees leave your company. Like resetting their password, connecting, on their behalf and copy all their content to a shared folder directly before to delete their account for real (cleaning up in your OBIEE and in your LDAP).

                                    1 2 Previous Next