Post reply

Security for a Database with SQL Server Express 2005 Backend & MS.Access Front end

  • June 30, 2010 at 8:31 pm

    #226283

    Hi,

    I am developing a database with SQL Server 2005 Express as Back End and Microsoft Access as Front End.

    The database should be used in a multi-user environment. I need to have multiple logins with different types of users (high level- can access all details, low level - can't access all)

    Iam wondering which is the best way to do?

    Iam new to SQL Server.

    Please help me.

    Thanks in advance

  • July 1, 2010 at 12:36 am

    #1187468

    http://msdn.microsoft.com/en-us/library/aa337552.aspx

    http://msdn.microsoft.com/en-us/library/ms188659.aspx

    Hope this will help

  • July 1, 2010 at 6:24 pm

    #1187973

    Thank you very much

  • July 2, 2010 at 8:50 am

    #1188254

    If you are trying to limit what forms and reports some users can see, you will also need to implement some sort of security scheme on the Access front-end. SQL Server security only limits what SQL Server objects a user has permissions for. On the Access side, you have two options, Access User Security, or using a Windows API call to determine the OS level user. In general if a user is not allowed to view a specific form or report, you will probably want to limit your menu choices for that user.

    A user that gets a message that they don't have permissions to view a specific form or report is more likely to start looking for ways to get at that object.

    Wendell

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • July 4, 2010 at 3:23 pm

    #1188631

    thanks a lot for your answer.

    Is there any way of using the windows login for username and password (novell) to access my database.

  • July 4, 2010 at 4:13 pm

    #1188637

    What do you mean "novell"? Do you have an NDS authentication scheme?

    If you can authenticate with Windows, you can add a login to SQL Server Express suing Windows authentication, and assign security to that account.

  • July 7, 2010 at 10:56 pm

    #1189996

    thanks.

    got it

Viewing 7 posts - 1 through 6 (of 6 total)

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