From the course: Microsoft SQL Server 2022 Essential Training
Join today to access over 24,000 courses taught by industry experts.
User roles and permissions - SQL Server Tutorial
From the course: Microsoft SQL Server 2022 Essential Training
User roles and permissions
- [Instructor] The security of your database is primarily maintained by assigning users to the correct roles that give them the permissions that they need to do their jobs, while also keeping them out of things that they shouldn't have access to. Let's now give our new user Octavia some additional permissions so that she can gain a deeper level of access to perform work on the server And in our databases. Octavia does not have the authorization to adjust her own permissions though, so in order to give her permissions, I need to be using a system administrator account. If you're still connected to your instance with Octavia's account, we need to switch over to the sysadmin account, either using our Windows authentication account or the SA login. Then, when we're using that connection, we'll go into the "Security" folder and expand "Logins", and then finally, double click on Octavia's account. In the "Server Roles"…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.