GRANT privileges and ALTER attributes
Once roles are created, you grant them specific access control privileges on objects, like tables and views. Common privileges being SELECT, INSERT, UPDATE, etc.
Imagine you're a cofounder of that startup and you want all of your data scientists to be able to update and insert data in the long_reviews view. In this exercise, you will enable those soon-to-be-hired data scientists by granting their role (data_scientist) those privileges. Also, you'll give Marta's role a password.
Bu egzersiz
Database Design
kursunun bir parçasıdırEgzersiz talimatları
- Grant the
data_scientistrole update and insert privileges on thelong_reviewsview. - Alter Marta's role to give her the provided password.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Grant data_scientist update and insert privileges
___ ___, ___ ON ___ TO ___;
-- Give Marta's role a password
___ ___ marta ___ ___ 's3cur3p@ssw0rd';