From the course: Database Foundations: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
SQL Server user permissions
From the course: Database Foundations: Administration
SQL Server user permissions
- [Instructor] Creating user accounts and assigning permissions in SQL server is similar to PostgreSQL, but there's a few minor differences. The first difference is that SQL server treats individual users and groups separately. In the sidebar for the SQL server instance, expand the Security folder and you'll find a folder for Logins. These are the individual user accounts. Below that we have a folder for Server Roles. These are the group accounts. Each login can be assigned to one or more server roles and these will confer a number of different permissions that help split up administrative responsibilities. For instance, there's a role for the security administrators, which will give access to a different set of tools and permissions from the disk administrators. For now, we're going to focus on just the individual accounts found in the logins folder. Here, just like in PostgreSQL, we see a number of different…
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.