I am not a DBA and am a beginner at SQL.
We have a client running SQL that needs to grant permissions to a DB to a specific user.
The DB does not appear in the list of DB's available for connection for this user.
Here is the request from the user:
I just finished writing a Crystal report that utilizes data from both databases (PRODUCTION and unipoint_Live) to measure our suppliers’ on-time delivery performance, quality performance, and combined score. This is something we must do for AS9100 compliance and has been (until now) a manual process.
The report pops up to ask for a username and password when trying to connect to the uniPoint_Live database.
The folks at unipoint have advised that this may be because the username support (which is already utilized for JobBOSS reports) does not have permission to see the unipoint database.
They recommend that the user be able to access both databases for situations like this.
Any input is appreciated and thanks for understanding.