← Customer Feedback for Redgate Settings and activity 1 result found Major KNOWN Issue --- Stop requiring product to login to all databases on server 32 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 4 comments · SQL Search » Graphical User Interface · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment Jacob commented · Nov 3, 2022 · Edit… · Delete… This should be trivial to fix: whatever SQL query SQL Search is emitting to enumerate databases on an instance just needs to have a condition added to its WHERE clause to check whether the current user has access to a given DB, eg: ...WHERE has_dbaccess(name) = 1 or similar. Save Submitting... Jacob supported this idea · Nov 3, 2022
Jacob
supported this idea
·
This should be trivial to fix: whatever SQL query SQL Search is emitting to enumerate databases on an instance just needs to have a condition added to its WHERE clause to check whether the current user has access to a given DB, eg:
...WHERE has_dbaccess(name) = 1
or similar.