Solved

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

Posted on 2010-08-19
2
203 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
ID: 33477843
you need two statements

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

Author Closing Comment

by:Steve Samson
ID: 33478324
Exactly I thought there was more to it.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

12 Experts available now in Live!

Get 1:1 Help Now