June 30, 2010 at 8:31 pm
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
July 1, 2010 at 6:24 pm
Thank you very much
July 2, 2010 at 8:50 am
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
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 7, 2010 at 10:56 pm
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