From the course: Database Foundations: Administration
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Column-level permissions
From the course: Database Foundations: Administration
Column-level permissions
- [Lecturer] User permissions can get very specific. We've looked at granting permissions to an entire schema, which will include all tables, views and other objects within the schema. We've also seen that you can grant permissions to specific objects such as a single table. Access privileges can get even finer-grained though. Most RDBMS platforms support granting permissions down to the column level. I've got the Column_Permissions text file open in a new query. It's attached to my SQL server database. Let's first create a new user with the name Yusef. Now we can grant read-only access to a single column in a table with the command that I have listed here on line 7. This specifically targets only the company column in the sales.customers table. So we're going to grant SELECT permission on the object sales.customers and then in parentheses company to Yusef. Let me go ahead and run my number 7. Now the PostgreSQL RDBMS…
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.