Description
When an object has the ALL privilege, any individual privilege explicitly granted (i.e. create, select, insert, ...) after that has no effect on the privilege list because ALL implies the role or user has all those privileges.
However, when any of the new privileges list (create, alter, drop) is granted before, and then the grant ALL happens, those privileges are not removed. We should keep the GRANT ALL consistent and remove any individual privilege (except the OWNER privilege) from the list.
Attachments
Attachments
Issue Links
- links to