A. Agius
Reputation: 1271
GRANT VIEW on 1 database
Is there any work around 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
Upvotes: 1
Views: 3985
Answers (1)
Aaron Bertrand
Reputation: 280570
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.
Upvotes: 3
Related Questions
- Permissions to view certain databases
- Grant Select on a view not base table when base table is in a different database
- Grant permission for a view that uses tables form other databases
- grant read access on a view but not on it's underlying tables from other databases
- GRANT a user to view single database? (deny viewing the rest)
- How do I allow all SQL users to read from a view
- SQL is it possible to grant permission to the view and not the user to access other db?
- View that accesses two databases
- Cross-database view permissions
- Grant permission to only a view