Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsuresh
Starting Member
22 Posts |
 Posted - 2012-11-22 : 08:34:59
|
What is difference between login & schema? suresh |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-11 : 12:30:43
|
quote:
Originally posted by gsuresh
What is difference between login & schema?suresh
you know what instance is, right?now how can u get into the instance? you need to log into the instance.so you need a login for that.if you want to give access to a database for few users, you need to create users for that database and need to map those user accounts to the login accounts.users- to access databaselogin- to access instanceschema is just like a name space like name spaces in xml.schema can be used for organizational identity purpose.schema is strictly not used to provide security. It is only used for naming purpose.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
 |
|
|
|
|
|
sql server 2008