logins,schemas,users

• kurrarghu

  SSC Rookie

  Points: 46

  More actions

  October 26, 2007 at 2:11 pm

  #199508

  could anyone plz explain me with a n example whats the exact diff btween user,login,schema,roles n what the exact use of creating them

  could you plz even say me the relation btween them

• Big Data Man

  SSCrazy Eights

  Points: 8536

  More actions

  October 30, 2007 at 6:49 am

  #746611

  Hi,

  Ok, here's the breakdown:

  1. Login = To only access SQL Server, you first must have a login to server

  2. User = To access a database, a login must be mapped to database. At this point, you become a database user via your login

  3. Schema = This provides a way of organizing database object ownership, which is mapped to a database user

  4. Role = This provides a way of controlling what a database user can do within context of a database

  Thanks,

  Phillip Cox