Home Forums SQL Server 2005 SQL Server Newbies I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance RE: I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance

  • robin.pryor (3/27/2014)


    Sean Lange (3/27/2014)


    robin.pryor (3/27/2014)


    MarkusB (1/7/2009)


    SQL DBA (1/7/2009)


    I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance

    You call yourself SQL DBA and ask such a basic question ?

    As Grant already said start reading Books Online and if you don't know where to find it it's here:

    http://technet.microsoft.com/en-us/library/ms187648.aspx

    People are supposed to be able to come here for answers so they can learn. They shouldn't get belittled for not already knowing the answers. People like you are why we can't have nice things. Jerk!

    While I agree that the comment was a bit harsh, this thread is over 5 years old. 😉

    But the point is valid and if it reaches even 1 person, which it did, I feel better. 😀

    And I feel good that I was helpful 5 years ago.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning