DQL Access tables from different Repository

Selvameena

Hi All,

Is it possible for a superuser from one repository can access/update the tables from different repository?

I wanted to make some changes in dm_user in RepA. But I dont have superuser account details in RepA. But I know the superuser in RepB.

So can I login as superuser in RepB and access/update dm_user in RepA? I know DQL is not SQL. But still wondering whether it should be possible?

Eg: Select * from RepA.dm_user where user_name='user';

Thanks,

D. Selvameena

Wiesnoepersad

NO NO NO:-)

Not with dql!