Soldato
- Joined
- 30 Sep 2005
- Posts
- 16,678
Not sure if this question is best asked in here or in the enterprise section.
Basically I have built a standalone non-domain joined SQL server running a single database. I want to give a specific user read-only access.
I've gone into SSMS, opened up the database, clicked into security and created a user with db_reader permissions.
The account then appeared under global security, and in testing they can login via SSMS which I'm not 100% sure about?
Have I done the right thing? The user is just running basic SQL queries, nothing fancy.
Basically I have built a standalone non-domain joined SQL server running a single database. I want to give a specific user read-only access.
I've gone into SSMS, opened up the database, clicked into security and created a user with db_reader permissions.
The account then appeared under global security, and in testing they can login via SSMS which I'm not 100% sure about?
Have I done the right thing? The user is just running basic SQL queries, nothing fancy.
Last edited: