Announcement

Collapse
No announcement yet.

Creating a SQL 2005 User

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating a SQL 2005 User

    Hi all

    I have started writing a web app that for the first time will use a MS SQL server as the database (normally use MySQL). I have tried creating an account but it doesn't appear to have the rights to look tables or make changes.

    Anyone got a link to a nice web site that explains how this is done correctly and keeps security integrity?

    Cheers
    Server 2000 MCP
    Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

  • #2
    Re: Creating a SQL 2005 User

    Just google SQL 2005 permissions and you'll get good results.

    in SQL when you create a user account at the "server level" meaning within SQL not the Windows server, by default that account is assigned to the public server role which has no rights but to connect to the sql instance.

    You need to right click that user > properties, then go to the User Mapping screen and assign addtional permissions at the database level.

    Comment


    • #3
      Re: Creating a SQL 2005 User

      you can take a look at these pages:
      http://msdn2.microsoft.com/en-us/library/ms187936.aspx
      http://msdn2.microsoft.com/en-us/library/ms189751.aspx
      http://msdn2.microsoft.com/en-us/library/ms173463.aspx

      it is pretty detailed and explains a good bit about dB roles with SQL 2005.

      i know that there are two sets of permissions you have to manage to allow access... the dB role, and the server permissions. you can click on the dB and create the user, but that only creates the role. then you have to go to the management portion of the mang studio and create the server login.

      hope that helps some, but i am no master at 2005 (yet)... i actually ended up having to reinstall and actually remember the pwords to get anywhere. 2005 is much more *secure* than 2000 to the point of frustration sometimes.

      good luck!
      its easier to beg forgiveness than ask permission.
      Give karma where karma is due...

      Comment


      • #4
        Re: Creating a SQL 2005 User

        Actually, if you create the login and grant them access to the database the user will then be created in the database for you. You can specifiy what rights to the database the user has when you grant them access from the login.

        Comment


        • #5
          Re: Creating a SQL 2005 User

          Thanks for the replies guys. Just got around to doing this and all went well. Thanks again!
          Server 2000 MCP
          Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

          ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

          Comment

          Working...
          X