Drops the specified role. If there are any references to this
    role in another role or ACL, then the DROP ROLE statement fails.

    The RESTRICT clause is the default.