Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The web development team sent me the following to forward to you: Create database users [sql server authentication] with passwords, no need to connect them
The web development team sent me the following to forward to you: Create database users [sql server authentication] with passwords, no need to connect them to credentials or certificates. You can create the users with any process you choose, just be sure to document how you did it and email it back to me, like a step-by-step tutorial. That way we can have some of the junior DBAs on staff replicate your work for specific user accounts when we're ready, we don't want to bother you with the busy work. We will need the following for the user templates [users]; o Human Resources, must have access to schema 1, 2, and 4. They'll be in-charge of making all updates that are necessary, so give them full permissions. o Accounting, need access to Schema 1, and the Address Schema, they'll need to pull data to know where to send paystubs and tax forms, so assign the permissions accordingly. o Sales, who will need access to the Facility Schema, and Address Schema, they requ
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started