Upgrading or revoking custom resource permissions, resource create-permissions and global resource permissions fails when another custom permission of the same name exists for another resource class. This bug occurs because the correlated subqueries to look up a custom permission by name are not correctly referencing their outer table in some instances.
This affects:
upgrading the with-grant-option of resource permissions
revoking resource permissions
upgrading the with-grant-option of resource create-permissions
revoking resource create-permissions
upgrading the with-grant-option of global resource permissions
revoking global resource permissions
Note that this does not affect system permissions and occurs regardless of recursive or non-recursive SQL profiles.
Upgrading or revoking custom resource permissions, resource create-permissions and global resource permissions fails when another custom permission of the same name exists for another resource class. This bug occurs because the correlated subqueries to look up a custom permission by name are not correctly referencing their outer table in some instances.
This affects:
Note that this does not affect system permissions and occurs regardless of recursive or non-recursive SQL profiles.