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.
Diese Übung ist Teil des Kurses
Creating PostgreSQL Databases
Anleitung zur Übung
- Remove the
INSERT,UPDATE, andDELETEprivileges that were granted to user accountklopezfor theloantable in thedevelopmentschema.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Remove the specified privileges for Kim
___ ___, ___, ___ ON ___.___ FROM ___;