Run report containing data from multiple schemas

[marcelgerr]

Hello,

I want to have a report available in multiple company DB's containing data from all those company DB's. In the past (version 9.3) this was possible because in the end always the same database user would be used to connect to the database.

Now however when running the report in version 10 I have to set a number of Object Privileges to a number of database users to work around this issue.

Is there another way perhaps to accomplish my goal?

[mgregur]

Hi,

this is standard behavior as of 10.0. When created, every Schema (Company) gets a separate user with privileges only to that Schema. This means there is no other way but to manually alter privileges.

BR,

Matija