Oracle - SQL Server DB Link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle - SQL Server DB Link

  1. #1
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    I recently changed the default Oracle username/password. The developers access the Oracle database for crystal
    reports via sql server using odbc and somewhere within sqlserver they have hardcoded the default password.
    They can no longer connect/read their reports. I'm wondering
    if the solution to this will be to create a database link to allow them read only access to the Oracle database. I'd like to change the password in Oracle anytime without worrying about the effect this will have on other applications.

    Any suggestions/comments will be greatly appreciated.

    Thanks



  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Anyway you look at it they're going to need a username/password that you can change at any time.

    I agree with you that it should be a schema that gives them read-only privs to objects.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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