revoke fails if you attempt to revoke permissions from user-defined roles in a local temporary database.
