How to restric database aceess

  • Hi

    How to restrict the database access other than project team(suppose 5 users)

    need to give access only project team.

    Thanks in advance

  • Setup a active directory security group. Add you project team members to this group. Add the security group as a SQL Login. Map users to the database you wish them to access. Apply roles to the Login.

    Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply