I'm currently learning the differences between PostgreSQL and MySQL as I've got a new project and I also intend to migrate my existing software from MySQL to PostgreSQL. I've actually started creating an HTML table with a comparison of commands (for users/databases/command prompt, etc) between the two. After reading an answer here I've notice that
role seems to be used as a group. With MySQL I have two users, basically public (
UPDATE permissions) and an admin user with a couple additional permissions.
So basically in the Windows 7 command prompt (local development only)...
- Is a role a user, group or a loosely used term specific to PostgreSQL?
- How do I grant only specific permissions to a specific user, for all tables in a database?
- How do I grant all permissions to a specific user, for all tables in a database?
- How, if at all, does a role compare to a user when using
REVOKEfor user permissions?