Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between login and a user?
- 13 Answers
- 31973 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
What is amo? : sql server analysis services, ssas
Explain the difference between clustered and non-clustered index?
What are difference between Cluster index and Non-Cluster index?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain the difference between primary keys and foreign keys?
List down some advantages of sql stored procedure?
Explain the functionalities that views support?
What are the triggers in sql?
How to create database with physical files specified in ms sql server?
What command is used to delete a table from the database in the sql server and how?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Name some of the open source software that you can use in alternative to SSR?
What are the different types of backups that exist?
How to drop existing views from a database in ms sql server?
How to find the list of fixed hard drive and free space on server?
