Forum Discussion
rlmariz
Jan 24, 2024Copper Contributor
User Full Control Only DataBase One
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.
- olafhelperBronze Contributor
rlmariz , more then easy, create that user and add him in the database of mind to the database role "db_owner", see
- 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