Ideal way to grant read write execute to few logins

Question

We are planning on creating 4 service accounts which need read write execute permission What wud be the ideal way Is it better to implement through roles Please guide and thanks for ur help

Answer 1

Hello,

Service accounts for the SQL Server services like database engine? Then see Configure Windows Service Accounts and Permissions

Answer 2

I am not talking about these service accounts

the logins that we will be creating are used by applications to connect to sql server

Answer 3

For read/write access you can add then to the database role db_datareader

The better option is to create an own database role, grant required permissions for the role and add the database user to that role.

Answer 4

Hi NeophyteSQL,

You can add the database user to the membership of db_datareader and db_datawriter.
For example:

USE [DB]  
GO
ALTER ROLE db_datareader ADD MEMBER <user>;  
Go
ALTER ROLE db_datawriter ADD MEMBER <user>;  
Go

Best Regards,
Amelia