From the course: Database Foundations: Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Granting and revoking permissions
From the course: Database Foundations: Administration
Granting and revoking permissions
- [Instructor] As a system administrator, you have the ability to say who can do what in your database. Once a user has authenticated with the server, the RDBMS looks to see what set of permissions have been granted and what activities there'll be allowed to perform. You may be familiar with read write permissions on your computer's file system. If you set a file as read only, it means that you can open and review it but you can't make any changes to it. The same granular level of control applies with database permissions and securables. Just like with creating a new table object within the database, you can add users and define permissions using SQL commands and keywords. The grant command is used to give a specific permission to a specific principal user or group account. The grant command is how you define what users are allowed to do. The opposite of that is the revoke command. It's used to remove a previously…
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.