Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!
To grant access to a user for a specific database, use the following commands:
Create a login (if it doesn't already exist):
CREATE LOGIN YourLoginName WITH PASSWORD = 'YourPassword';
Grant access to the database:
USE YourDatabaseName; CREATE USER YourLoginName FOR LOGIN YourLoginName;
Grant a role or specific permissions:
EXEC sp_addrolemember 'db_datareader', 'YourLoginName'; -- Grants read access