From the course: Database Foundations: Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Server authentication and login accounts
From the course: Database Foundations: Administration
Server authentication and login accounts
- [Instructor] The first step in securing the contents of a database is to be able to identify different users so that you know exactly who they are. This will allow the relational database management system to assign the proper permissions. The simplest way to verify that a principal user is who they say they are is with a username and password. These are typically stored within the database server itself. Then in order to log in, all the user needs to know is their assigned name and password and the credentials are matched against a known principal's account that was created previously. When we created our database servers in Docker, we created a default administrator login account with this method. In SQL server, that user has the name sa, which stands for system administrator. PostgreSQL uses the default name postgres for its administrator account. These are the two accounts that we've been using all along and…
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.