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...
1- Security --> Logins --> New Login. Default Database: Master (for the connection permission)
2- On the same screen (Login - New) --> User Mapping --> Select the databases which you access
3- For each databases that you select, you can select dbowner on the same screen. This (dbowner) provide the user what ever he wants
Other ways may be confuse you.
2- On the same screen (Login - New) --> User Mapping --> Select the databases which you access
3- For each databases that you select, you can select dbowner on the same screen. This (dbowner) provide the user what ever he wants
Other ways may be confuse you.