Join Adam Wilbert for an in-depth discussion in this video Granting access to a database, part of Database Fundamentals: Administration.
- View Offline
- Adding permissions to users follows a hierarchy…that controls where they can go…and what they can do in the database.…After determining what, if any,…permissions the user requires at the server level,…the next step is to determine their needs…when it comes to accessing specific databases.…Let's continue working with Maria's user account,…and we're going to give her some permissions…to access the H+ Active database.…Here I've logged out of my SQL Server instance,…and I'm just going to log in as Maria real quick here.…I'll change the authentication to SQL Server authentication.…We'll type in Maria's username,…and her password is 123 right now.…
Go ahead and press connect,…and that will connect to the server as Maria.…Now let's take a look at our databases.…Let's expand the databases folder,…and I can see the H+ Active database here.…Let's try and expand that, but we get this error message…saying that the database is not accessible.…So, let's log back into our system administrator account,…and give Maria some increased permissions.…
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database