What is the difference between login and a user?
- 13 Answers
- 27958 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / infodba
Login is a server principle and User is a database principle
Each server principle can be a guest user as a public role for each database can view any database.
But a contained user of a database cannot access other databases and cannot be a guest login for the server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain rdbms?
Which table keeps information about stored procedures?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How do I find the sql server version?
How raid can influence database performance?
Why I am getting this error when dropping a database in ms sql server?
What is inline variable assignment?
What is key set driven?
What are cursors in ms sql server?
How to rebuild master databse?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How can sql server instances be hidden? : sql server security
What are various limitations of the views?
What is join and name different type of joins?
