I have a Oracle Account called "psdb" which has the proper Oracle priviledges and works just fine logging into ProfileStage UID. But when we create other non "psdb" users they are failing with ORA-01031 or insufficient priviledges.
These users have the proper role, priviledges and have a synonym to the "psdb" account. This seems to be what I know as proper to allow access.
What am I missing that continues to disallow access in Oracle for these users?
Thanks