We are having a permissions problem. There are two database instances on
separate machines, which are the supposed to be the same structure.
One instance works and one doesn't
To find out what is wrong I need to identify and compare two databases
I need to identify what objects these roles have been granted priviliges
(select, insert, update,delete) and then compare them.
I propose a sql statement spooled to a file which would list each role
each object that it has privileges on.
The at the unix level diff the files.
Can any one help me with the correct SQL statement to gather the info I
Oracle is 7344
OS is Digital unix V4.0e