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)


    Ah but the question "What landed me on this post in the 1st place?"

    I'm a SQL DBA and I've never given a crap about schemas. I know what they are by definition, but have never once considered using them, because I'm probably too old-school. I think in terms of logins, groups, roles, and users. Now I'm in a circumstance where everybody and their mailman has had their hands in the cookie jar on this production server and nobody currently working here knows why things are the way they are. Should I create a new post to get flamed on "You call yourself a DBA....." or do you want to take a stab at answering me here?

    The problem isn't that the OP didn't know, the problem is that this is clearly explained in BOL which should be the first option to look for answers for any SQL Server DBA. A question posted as this would have gotten different responses:

    I've been studying about users, logins, roles and schemas, but I'm still confused. Can you help me understand the differences? I see that the user, login and schema are all the same, but the definitions are different.

    The original questions seemed as: "Could you do my homework for me?"

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2