New answers tagged dba
That is how it tends to work in small companies, but that is how it always used to work for small companies: at a small scale an expert database person was often seen as a grandiose expense when all the devs can do the basics. This is not really a factor of ORMs and noSQL becoming popular recently. ORMs still have datastores behind them that someone needs ...
Your answer is right here in SO already: Restrict SQL Server Login access to only one database. Just in case the link is broken: 1. Connect to your SQL server instance using management studio 2. Goto Security -> Logins -> (RIGHT CLICK) New Login 3. fill in user details 4. Under User Mapping, select the databases you want the user to be able to access ...
In management studio, right click Security in object explorer and choose new login. Then, on the user mapping tab, you select which databases your login can access. (Login in at the server level, and a user is at the database level).
Top 50 recent answers are included