Forum Discussion
Grant permissions to specific Database
I'm trying to do this: User_1 can't see all databases User_1 can see only specific databases User_1 can do whatever he wants on specific databases I already tried these solutions: Revoke s...
MEspo94 , that's not possible to achieve.
A user can "see" all databases, doesn't mean he can access all.
If you revoke "View all databases" permission, then the user can "see" on the database he is currently connected to, no others, even not databases he has permissions for.