You need to establish a set of permissions that you can routinely assign to new users.
What should you create?
You need to establish a set of permissions that you can routinely assign to new users.
What should you create?
To establish a set of permissions that can be routinely assigned to new users, you should create a role. Roles are predefined sets of permissions that can be easily distributed among users. This simplifies the process of managing user permissions, ensuring consistency and reducing the potential for errors when granting access. By assigning a role to a user, you ensure that they receive all the permissions associated with that role in a single step, rather than configuring permissions manually for each new user.
SQL Role. CREATE ROLE creates a set of privileges which may be assigned to users of a database. Once a role is assigned to a user, (s)he gets all the Privileges of that role. By creating and granting roles, best means of database security can be practiced.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-role-transact-sql?view=sql-server-ver15
Well Done!
SQL roles are useful for administering privileges when a database has many users. Roles provide a more powerful way to grant privileges to users' sessions than to grant privileges to each user of the database, which easily becomes tedious and error-prone when many users are involved.