Database Links for Roles?

Hi Everyone,

I have about 10 schemas that have to be able to see the same objects in a schema on another instance.

I don't fancy creating a separate DB link for each schema, so I was wondering if it's possible to create a role and create the database link for that role.

Is this possible? The create database link syntax seems to suggest that links are only applicable to schemas.

no, the database needs to have a username and password to connect to

OK, Davey, thanks anyway.

Bye
Peer