User Full Control Only DataBase One

Copper Contributor

How can I create a user who has access to only one database but has complete access to that database and can create and drop objects, select, insert and drop rows.

3 Replies

@rlmariz you can do this by connecting to your SQL Server instance using SQL Server Management Studio, right-clicking on the Security folder, choose New > Login, fill in the user details, select the desired database. Under User Mapping, configure access settings, choose the db_owner role in the Database Role Membership section, and click OK to create the user.

 

Please note that the above steps will give the user complete control over the specified database and its objects.

 

You can read more at Microsoft Learn

 

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
Note: 

If this post helps, please consider Accepting it as the solution { Mark as best responses} to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
 
Best Regards,
Dallas.

@rlmariz , more then easy, create that user and add him in the database of mind to the database role "db_owner", see

Database-Level Roles - SQL Server | Microsoft Learn

As mentioned you grant db_owner right to a particular user for an specific database. Note that you won’t be able to see and handle sql server agent jobs