Post reply

Restrict User to one instance on SQL server

  • March 1, 2011 at 3:59 am

    #231950

    How can i Restrict User to one instance on SQL server

  • March 1, 2011 at 4:14 am

    #1292807

    by default users are configured with instance/database specific access as long they do not belong to any group which have the permission across domian(in case of windows login)

    ----------
    Ashish

  • March 2, 2011 at 6:34 pm

    #1293816

    typically when you add a login in an instance it applies for the instance.

    If it is not SQL 2008 -

    If its a domain login that is an admin on the server. i.e windows admin, then 'builtin admin' login in SQL grants the user rights by virtue of being Win admin across all instances on the server.

    If it is SQL Server 2008 this doesn't apply because Builtin admin login isn't there by default like in sql server 2005

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

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