list normal users and corresponding ops$users in Oracle database in groups
1000058May 17 2013 — edited Jun 6 2013Hi,
We are having Oracle database version 11.2.0.2 on Oracle Ent. Linux 5.1. Basically, according to our requirement, we need to list similar users in the database which are having individual usernames as well as their corresponding ops$usernames (in one query).
Eg. in the database if have users 'xyz' and 'ops$xyz', 'abc' and 'ops$abc', then we need to write a query which can list this users together in groups as below;
xyz
ops$xyz
Similarly,
abc
ops$abc.
Can you help me write a query so that I can list all these similar users residing in my database together.
Also, later I need to find out the roles and privileges assigned to these users once its listed.
Thanks in advance.
~ Rahul