I am learning Microsoft SQL.

I have 4 users named Bowler, Mngr, Faculty, & Student that were created on the master database. I also have a user-defined role named Week3 that was also created on the Master database that grants permission to Select, Update, Insert & Execute.

Next, I have a database called BowlingLeagueExample where I have 2 schemas named Bowlers & Matches that I just created each one having access to only a certain set of tables. Then I also have a database called SchoolSchedulingExample with 2 schemas I have created this database called Faculty & Students where again each one having access to only a certain set of tables.

I only spent the last 4 hours getting that far. Now I need to give the user Bowler access to only the schema Bowlers & the user mngr access to only the schema Matches., the user Faculty access to only the schema Faculty. & the user Student access to only the schema Students.

Finally to designate what these users have access to do, I need to use that Week3 role I already created.

I am not sure if I need to create these users & that role in each specific database or something since I keep running into errors when I try to complete the process & am hoping someone can help me out.