Re: Permissions

From: Uri Dimant (urid_at_iscar.co.il)
Date: 10/30/05

  • Next message: Uri Dimant: "Re: Database Permissions"
    Date: Sun, 30 Oct 2005 09:58:11 +0200
    
    

    Create a group and add the users you want tio deny access
    Take a look at below stored procedure in the BOL.
    sp_revokedbaccess [ @name_in_db = ] 'name'

    "icrp@msn.com" <icrpmsncom@discussions.microsoft.com> wrote in message
    news:9F945ED7-1C19-44CC-A15E-C44D30CCEB65@microsoft.com...
    > How can i Deny access to my domain users to my sql databases and grant
    > access
    > only to some users. If a make Deny to all users in domain and if a create
    > the
    > necessary users with Grant Access to some databases, the can access the
    > databases?
    >
    > Best Regards


  • Next message: Uri Dimant: "Re: Database Permissions"