How to drop all objects with permissions for a role



How do I enumerate all the permissions for a role and then drop them? I
would like to do it with a SQL script, not through the enterprise manager.

Thanks in advance.

Valerie Hough


.



Relevant Pages

  • Re: Auditing a Domain from a Guest Account
    ... In NT4 Guests can enumerate users & groups and shares, ... NTFS permissions usually not; you can only enumerate what you can ... Am I nuts for even entertaining the notion that a guest account ...
    (comp.os.ms-windows.nt.admin.security)
  • Re: Security User access question
    ... >> I am not even sure if Active Directory can provide this ... >it could be done with vbscript. ... >permissions, what permissions they have and, in the case ... >enumerate the group membership to find out the users. ...
    (microsoft.public.security)
  • Re: Security User access question
    ... > I am not even sure if Active Directory can provide this ... permissions, what permissions they have and, in the case of a group, ... enumerate the group membership to find out the users. ... The other option would be to combine vbscript with perms.exe (from the ...
    (microsoft.public.security)
  • Re: Monitor system
    ... sure your ASP.NET worker thread has permissions to enumerate the processes ... Eric Lawrence ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How To Display File Permssions Recursively on File Server
    ... server with approximately 300 user home directories which would show ... the 'Everyone' group had permissions and what those permissions are? ... Use Xcacls To Enumerate Ntfs PermissionsEXE to enumerate NTFS folder ...
    (microsoft.public.windows.server.general)