Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

difference between login, schema and user? Expand / Collapse
Author
Message
Posted Friday, August 03, 2007 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 03, 2007 9:41 AM
Points: 1, Visits: 1
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,
Post #387843
Posted Friday, August 03, 2007 9:59 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:05 AM
Points: 779, Visits: 222
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.
Post #387850
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse