Solved

How do I revoke access to all objects of a database except for a specific view?

Posted on 2010-08-19
2
201 Views
Last Modified: 2012-05-10
How would I revoke access to all objects in a database with the exception of select permissions to a view within that database The name of the View is MYVIEW and the user account is MYACCOUNT?
0
Comment
Question by:Steve Samson
2 Comments
 
LVL 51

Accepted Solution

by:
HainKurt earned 500 total points
Comment Utility
you need two statements

revoke all from userid;
grant select on viewname to userid;
0
 

Author Closing Comment

by:Steve Samson
Comment Utility
Exactly I thought there was more to it.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now