GRANT VIEW on 1 database

Is there any work arou开发者_运维百科nd to grant view on a particular database after executing the below code?, I am using MS SQL 2008 RC2.

REVOKE VIEW ANY DATABASE FROM <login>;

Thanks

As far as I know, REVOKE wins, so you may need to grant VIEW ANY and then deny on all of the other databases individually. This is less fun of course but you can automate this without having to do it one by one.