How To Create a New Login Name in MS SQL Server?
Submitted by: AdministratorIn previous tutorials, it is assumed that you use the "sa" (System Administrator) login name to connect to your SQL Server. But that is not what a normal developer uses to connect to the server, since "sa" has the ALL permissions granted. You need to create new login names and grant less permissions to them, and give them to developers.
To create a new login name, you can use the "CREATE LOGIN" statement in a simple syntax like this:
CREATE LOGIN login_name WITH PASSWORD = 'password'
To run "CREATE LOGIN" statement, you need to connect to the server with a privileged login name like "sa". See the tutorial example below:
-- Login with 'sa'
-- Create new login names
CREATE LOGIN ggl_DBA WITH PASSWORD = 'ABD_LGG'
GO
Command(s) completed successfully.
CREATE LOGIN ggl_Login WITH PASSWORD = 'LGG'
GO
Submitted by: Administrator
To create a new login name, you can use the "CREATE LOGIN" statement in a simple syntax like this:
CREATE LOGIN login_name WITH PASSWORD = 'password'
To run "CREATE LOGIN" statement, you need to connect to the server with a privileged login name like "sa". See the tutorial example below:
-- Login with 'sa'
-- Create new login names
CREATE LOGIN ggl_DBA WITH PASSWORD = 'ABD_LGG'
GO
Command(s) completed successfully.
CREATE LOGIN ggl_Login WITH PASSWORD = 'LGG'
GO
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How To Create a Testing Table with Test Data in MS SQL Server? |
☺ | How To Get the Definition of a View Out of the SQL Server? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Create a Large Table with Random Data for Index Testing in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |