[dba-SQLServer] REVOKE

In this case, we are revoking all permissions on a table for a particular 
login.  This used to work, but it turns out that a couple months ago, 
explicit permissions were granted to this login, so it overrules the 
revoke (I'm not the dba and don't do these tasks)  My boss has decided to 
just drop this login and rebuild it.  In this case, the revoke step was 
blocked due to the table being in use.  Now that I know how to use sp_who 
I can troubleshoot better.

Thanks,

Mark Whittinghill
Sr. Programmer Analyst
Protective - Asset Protection Division
636.536.5720
Mark.Whittinghill at protective.com



"Billy Pang" <tuxedo_man at hotmail.com> 
Sent by: dba-sqlserver-bounces at databaseadvisors.com
10/04/2005 08:38 PM
Please respond to
dba-sqlserver at databaseadvisors.com


To
dba-sqlserver at databaseadvisors.com
cc

Subject
Re: [dba-SQLServer] REVOKE






I would think an "access denied" issue would usually generate an error 
rather than hang the connection but I have never had to use a REVOKE ALL 
in 
a DTS before.   which database revoking taking place?  Is it revoking all 
permissions in the MASTER db?  maybe it is hanging the application that is 

executing DTS.


>From: Mark.Whittinghill at protective.com
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] REVOKE
>Date: Tue, 4 Oct 2005 15:00:12 -0500
>
>I have a DTS that has a REVOKE ALL step on a table.  If that table is 
open
>by a user when that step runs, should I expect an error, or expect it to
>just hang?  I am asking because this package hung on this step recently,
>and I am trying to isolate if that is the cause.
>
>Mark Whittinghill
>Sr. Programmer Analyst
>Protective - Asset Protection Division
>636.536.5720
>Mark.Whittinghill at protective.com
>
>
>-----------------------------------------
>Confidentiality Notice: This e-mail communication and any attachments
>may contain confidential and privileged information for the use of the
>designated recipients named above. If you are not the intended
>recipient, you are hereby notified that you have received this
>communication in error and that any review, disclosure, dissemination,
>distribution or copying of it or its contents is prohibited. If you
>have received this communication in error, please notify me immediately
>by replying to this message and deleting it from your computer. Thank
>you.
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com