To revoke set proxy or set session authorization you must be in the master database.
set proxy and set session authorization are identical, with one exception: set session authorization follows the SQL standard. If you are concerned about using only SQL standard commands and syntax, use set session authorization.
revoke all does not include set proxy or set session authorization permissions.