Description
I'm installing a new Policy Server and using Oracle as Policy Store.
I already created the policy store and imported the SiteMinder Basic Objects.
My issue is because I'm using 2 oracle users, the first oracle users is the owner of the Database Objects and the second one is for access only.
When I use the first user everything works fine, but every time I try to use the second one I'm get the following error:
Policy store failed operation 'MultipleSearch' for object type 'Root' . Table or view not found
Solution
The issue is because the second user is not able to find the SiteMinder Database Objects, as result the Policy Server throws the error "Policy store failed operation 'MultipleSearch' for object type 'Root'. Table or view not found".
In order to configure the second user to work with SiteMinder Policy Server, you may need to do the following:
For instance, let's say that you have 2 Oracle users smowner and smuser:
The above procedure must be done for all the objects in the policy store schema.