SQL Server – Understanding of SQL Server Role and Database Role
SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and database role. Server Role: Role Name Permission user can have bulkadmin Can run the BULK INSERT statement. dbcreator Can create,
» Read more