May 1, 2008 at 11:21 pm
Can somebody help me by answering the following question
How do Logins, Users and Schema work in SQL Server
May 1, 2008 at 11:42 pm
Anoop
You have asked a very general question .
You will the info you need on BOL, MS site and also in this site. Why dont you read up and then come to us for more specific questions.
"Keep Trying"
May 2, 2008 at 12:51 am
A summarized answer to your question - They are hierarchical access control system of SQL Server
Logins are required to access the server.
Users are required to access a database.
Schema is the access definition at object level.
Note: A login might have access to a server, but might not have access to a database.
A User is a login associated with a database, which by default has access to the server; but might not have access to a specific schema.
A schema by default has access to the database and the server.
Each object on a server is always associated with a schema. The schema is always associated with atleast one user, called the schema owner. Each database is associated with atleast one user, called the database owner, and by default has a schema dbo. The server is associated with atleast one login, called the sysadmin or sa.
Hope this helps.....
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply