How do you write a procedure for login?
I have table 'login(username,password,designation)'. I want to create stroed procedure to login.
...
...or Join us.
OriginalGriff |
4,639 |
CPallini |
1,153 |
Luc Pattyn |
1,075 |
CHill60 |
995 |
•
Apr 29, 2012
How do I create a SQL login?
Create a login using SSMS
- In Object Explorer, expand the folder of the server instance in which you want to create the new login.
- Right-click the Security folder, point to New, and select Login....
- In the Login - New dialog box, on the General page, enter the name of a user in the Login name box.
What is Sp_change_users_login?
Use sp_change_users_login to link a database user in the current database with a SQL Server login. If the login for a user has changed, use sp_change_users_login to link the user to the new login without losing user permissions.
What is login in SQL Server?
A login is a security principal at the scope of the SQL Server instance, and a SQL Server instance can contain numerous databases. ... Simply stated, a login allows you to connect to a SQL Server instance. Once you are connected to SQL Server instance, you will typically need access to a particular database.