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

Column-level permissions

From the course: Database Foundations: Administration

Start my 1-month free trial

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…

Contents