Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - "CREATE LOGIN" - Creating a New Login Name

By: FYIcenter.com

(Continued from previous topic...)

How To Create a New Login Name in SQL Server?

In 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 FYI_DBA WITH PASSWORD = 'ABD_IYF'
GO
Command(s) completed successfully.

CREATE LOGIN Fyi_Login WITH PASSWORD = 'IYF'
GO

(Continued on next topic...)

  1. What Is the Security Model Used in SQL Server 2005?
  2. What Are Security Principals Used in SQL Server 2005?
  3. What Is the Security Principal at the Server Level That Represents Your Session?
  4. What Is the Security Principal at the Database Level That Represents Your Session?
  5. How To Create a New Login Name in SQL Server?
  6. How To Verify a Login name with SQLCMD Tool?
  7. How To List All Login Names on the Server?
  8. How To Change the Password of a Login Name?
  9. How To Change a Login Name?
  10. How To Disable a Login Name?
  11. How To Delete a Login Name?
  12. How To Create a User Name in a Database?
  13. How To List All User Names in a Database?
  14. How To Find the Login Name Linked to a Given User Name?
  15. How To Verify a User name with SQLCMD Tool?
  16. How To Change the Name of a Database User?
  17. How To Delete an Existing Database User?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...