DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001
    Hornchurch, Essex UK
    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.


  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.