Post reply

creating user for server 2000

  • September 23, 2006 at 5:24 am

    #62282

    Hi!

      There

    well Now I am facin a acute problem.....

    I need to  create users.After creating  user  i.e user for student so that they  can access database from the server without having administrators  login...

    Now the problem I  face is My student they need to logon on as administrator   only then they  are able access the server.

    I  need to restirct them  from  using administrator logon and yet  access the database such"Northwind,Pubs,globalToys...etc"

    please help

    Regards

    phil

  • September 26, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • September 26, 2006 at 8:41 am

    #662487

    Once you've created a login in SQL Server you need to create a user in each database that the login needs to access.  You can do that in Enterprise Manager by expanding databases, your database, right-click on Users and select New Database User.  Then, you can grant database role membership and object permissions to the user.

    After the students have access to the correct databases, remove them from the Sysadmin server role and change the password for SA.

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply