Removing user privileges
It seems that success on the loan platform team is contagious. One of the team members, Kim Lopez, has been promoted and will be taking on a project management role. She won't need to make any modifications to the loan data going forward. However, having the ability to query the loan
table will still be useful in her new role.
This exercise is part of the course
Creating PostgreSQL Databases
Exercise instructions
- Remove the
INSERT
,UPDATE
, andDELETE
privileges that were granted to user accountklopez
for theloan
table in thedevelopment
schema.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Remove the specified privileges for Kim
___ ___, ___, ___ ON ___.___ FROM ___;