User handling in MS-SQL database
0
votes
2
answers
267
views
I have an MS-SQL installation, controlling different databases. This can be accessed using Microsoft SQL Server Management Studio 18. For doing that, I use Windows authentication.
In there, I have different databases. One of them has the following permissions (while checking "Properties", "Permissions"):
Users or roles:
Name Type
ANALYSE User
Permissions for ANALYSE:
Permission Grantor Grant With_Grant Deny
...
Connect False False False
...
Connect dbo True False False
I have modified the "Grant" column checkbox, but that modification is not taken into account.
I'm doing this because I want "ANALYSE" to be capable of accessing that particular database (I'm working with a connectionstring in a C# Entity Framework related program and I'd like to perform as least as possible source code modifications). When I access that database while having logged in as "ANALYSE" I get the following error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
The database is not accessible. (ObjectExplorer)
------------------------------
BUTTONS:
OK
------------------------------
Two questions:
- In order to access that database, is it correct trying to check the "connect" feature in the "permissions" page? If not, what else do I need to do?
- When I click a checkbox, how can I make sure that this gets stored instead of not taken into account?
**Edit: screenshots for better understanding**
As can be seen in the following screenshots, one "Connect" permission is granted, and all tables are indeed called "dbo.", nevertheless simply opening the database is not working:
Permissions screenshot:
The error message appears when I click on the + at the left of DB_Name:


Asked by Dominique
(609 rep)
Jan 20, 2022, 09:53 AM
Last activity: Jan 20, 2022, 03:29 PM
Last activity: Jan 20, 2022, 03:29 PM