BI Service Administrator Application Role is deleted in OBIEE 12C

NC125

Hi All,

I was working on creating new application roles in EM, unfortunately BI Service Administrator role was deleted by mistakenly.

I created the role again and added weblogic user but some how it was unable to get all the default roles and responsibilities before deleting, even it is not accessing to open repository in online mode by using the weblogic credentials. .

Do i need to do any more additional steps to work BI Service Administrator like before deleting ???

Please can some one suggest me the steps that BI Service Administrator to behave normally, so i will try to add any more missing steps from my end.

Thanks,

NC

Gianni Ceresa

Hi,

Did you try searching the forum?

Because it's apparently a trend to delete the admin app role or admin user in OBIEE lately

Also keep in mind you have a BAR provided with OBIEE which contains the basic security setup, so you can load that one and you get back the default security and then you can reapply your own things on top. Last but not least: backups.

https://www.youtube.com/watch?v=5CgBmj7Jz6Y&feature=youtu.be&t=18s

[Deleted User]

a) Inheritance:

BI Administrator must be a member of BI Author

b) Application Policies:

You forgot about those, right? You actually need the java policies for that app role as well!

NC125

Thanks Christian,

It worked after adding the BI Author role, but still am unable to connect the Repository in Online mode by using the default weblogic credentials.

Even i can able to make a new connection from ODBC driver to Repository database but when am trying to connect in online mode by using the weblogic credentials, it ended up by saying Logon Failed.

Do i need to add or delete any files in repository server to connect with weblogic user??

Thanks,

NC1

NC125

Thanks Gianni,

I just added the BI Author role to the Newly created BI administrator role then it worked like before.

Thanks

NC

[Deleted User]

You have to read my response further than "a)".

"b)" - Application Policies