To: You Subject: Database accounts and user function Thanks for looking into establishing all the database schemas and the administrator account. We're currently preparing to build account access on the intranet site but first need you to add some user accounts to the database so we can test out the connection on our end. We haven't decided yet exactly which employees we will be granting access too though, so for the time-being, I need you to setup some generic dummy accounts for a few of the departments. Just name the generic accounts after the job roles, we will later use these as templates for actual employees. 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]; 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. 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. Sales, who will need access to the Facility Schema, and Address Schema, they require read-only access, they don't need to modify any records, so assign restrictive permissions. We also want to test out views, and the websites ability to pull data from them, so setup a view to produce a list of all employees whom have not yet successfully completed their probation period assigned to their job role using the Roles and Employee table. Matt Kozi Solutions Architect, Coffee Bean Roasters mKozi@cbr.org