Post reply

Windows authentication in SQL Server 2005

  • February 3, 2009 at 2:11 am

    #155214

    Hi folks,

    i have SQL Server 2005 installed. i have created login with windows authentication. its fine, its created. when i logged in to database using the SSMS i am able to view all the data from all the databases. BUT i provided privileges to access one database only.

    is there any way to view data for the selected database only?

    i need to create a windows authentication login and it should be able vies the permissions for that db only.

    thanks,

    Ramu.

  • February 3, 2009 at 2:34 am

    #936961

    Is your login a member of the Windows Local Administrators group on the server? If so, that's where the problem is, as the BUILTIN/Administrators' permissions in SQL Server default to sa. It's good practice to remove BUILTIN/Administrators, but make sure you have another account with those permissions before you do so.

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

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