difference between login, schema and user?

• pavan kumar-427698

  SSC Rookie

  Points: 41

  More actions

  August 3, 2007 at 9:43 am

  #118068

  hai to every one,

  i am confused to understand schema and user. what is the difference between this two.

  could any one explain this topic.

  regards,

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  August 3, 2007 at 9:59 am

  #724576

  A login is a principal at the server level and can be granted/revoked/denied permissions at the server level.

  A user is a principal at the database level and can be granted/revoked/denied permissions at the database level. It is linked to a login.

  A schema is an organizational structure for objects within a database. Permissions can be granted/revoked/denied on whole schemas to users or roles.

  That's the simple version.