DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Links for Roles?

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    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.
    Last edited by Peer Jones; 07-20-2006 at 08:29 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, the database needs to have a username and password to connect to

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    OK, Davey, thanks anyway.

    Bye
    Peer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width