Re: is there a way to disable a database role?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
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