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)


    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. 😉

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/