From the course: SQL Server 2014 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Database-level users - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Database-level users
- In the previous demonstration, we created a login at the instance level. Now I'd like to create a user at the database level, and connect that user to the instance level log-in. So here in Management Studio, I'm gonna open up AdventureWorks 2014. In the very bottom item, Security, I'm gonna open that up, and then I'll open up Users, and we'll see a list of the existing users. I'll right click on Users, go to New User, and that'll take me to a dialogue box to create a new user. For Username, I'll just call it TestUser, and that should connect to the Login name, TestLogin, that we created earlier. On the Owned Schemas tab, we'll see a list of all the schemas available to us, no reason for this account to own any of them. The next one, Membership, I do want to go ahead and add this user to a few roles. I'd like to add it to the datareader role, and the denydatawriter role. So what this should accomplish is a user who can read data from the database, but they cannot write data to the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.