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"