Solved

select permission to remove a table

Posted on 2011-03-02
3
203 Views
Last Modified: 2012-05-11
I have 2 users database, pat  and ted
 how? remove the permission to read user table Pat sales.order
0
Comment
Question by:enrique_aeo
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 35020913
connect as sales (or dbo), and run this:
deny select on sales.order to pat

Open in new window

0
 
LVL 32

Assisted Solution

by:Ephraim Wangoya
Ephraim Wangoya earned 125 total points
ID: 35020963
try using revoke


revoke select on OBJECT::sales.order from Pat
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35021090
revoke would only remove the explicit permission, but not necessarily completely block the SELECT permission, if the permission has been granted via other roles, for example.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
This query failed in sql 2014 5 38
Conver SQL Server 2008 R2 from sql_latin1_general_cp1_ci_as to Arabic_CI_AS 9 32
SQL Recursion 6 33
How can I find this data? 3 23
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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

685 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