Re: is there a way to disable a database role?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/20/04

  • Next message: John Bell: "Re: SQL Server - Enterprise Manager" 
    Date: Fri, 19 Nov 2004 20:29:02 -0500

    Other than taking away all the permissions I don't think so. 

    -- 
Andrew J. Kelly  SQL MVP
"Richard Roche" <RichardRoche@discussions.microsoft.com> wrote in message 
news:E7D9AC2F-B2E6-4A2B-A25B-0CB825451150@microsoft.com...
> I've set all database permission to a role and then assigned users to that
> role.
>
> I'm in a transition to a new system and will want to drop the role, but
> would like to disable it so i don't burn my bridge during the transition.
>
> Is it possible to disable a database role?
>
> Thanks.
> -- 
> Richard
  • Next message: John Bell: "Re: SQL Server - Enterprise Manager"