Sample Header Ad - 728x90

How to Hide SQL databases from specific users

0 votes
2 answers
141 views
I am working on implementing Multi Tenancy on SQL Database server. we are implementing approach of keeping one database per client. I want to Hide databases of one client from the users of other clients. I know a way by making a user Owner of that database and then denying view to all databases. but this works only for one users. if any one knows a general solution please let me know.
Asked by user3510083 (29 rep)
Feb 14, 2025, 02:24 PM
Last activity: Feb 15, 2025, 03:11 PM