Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Security in Multiuser environment (Ms Access Project or Ms access database) Expand / Collapse
Author
Message
Posted Wednesday, July 7, 2010 10:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 28, 2010 4:34 PM
Points: 6, Visits: 29
hi,

Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have access to all details and some don't.

Which would be the best option in this situation (ms access project or database?)

I am new to Sql. I want the easiest method of implementing security.

please help

Thanks in advance
Post #948996
Posted Tuesday, August 3, 2010 1:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 12:26 PM
Points: 227, Visits: 238

Hi I have same problem, but SQL is 2008 express.

I created table with (user_name,password- hash,column admin - boolean)

I need solved how to store that user is entered and have admin access.

Maybe used temporary table where will info about that user entered coorect password...
Post #963081
Posted Wednesday, August 4, 2010 1:41 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 6:14 AM
Points: 271, Visits: 1,236
I've used the following to restrict user access. Usually by locking controls on a form or making things invisible

Dim stUser As String
stUser = GetLoginName

Select Case stUser
Case "DAVID", "KATHY", "JO", "Micheal"
'allow access
Case Else
'restrict access
End Select


Public Function GetLoginName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String

strUserName = String$(254, 0)
lngLen = 255

lngX = apiGetUserName(strUserName, lngLen)

If (lngX > 0) Then
GetLoginName = Left$(strUserName, lngLen - 1)
Else
GetLoginName = vbNullString
End If
End Function

GetLoginName returns the current users windows log in. I also have a table with columns for username and boolean columns for privileges such as "Can_Sign_Quote", "Can_Sign_PO". So I can check that table to see if user x has privilege y.
This works for me because I only have a few users and "real security" isn't a requirement. It's mostly used to prevent people from seeing things they don't want or need to see.
Post #963793
Posted Wednesday, August 4, 2010 3:31 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 7, 2014 11:41 AM
Points: 703, Visits: 4,519
On small scale, I've used something similar to dschubel, but I also used a bit field and bitmasks for access control. Makes a clean select case that doesn't have to be maintained as users change.

Larger scale I use AD group memberships.
Post #963861
Posted Thursday, August 5, 2010 10:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:43 AM
Points: 45, Visits: 215
kiranmai.gompa (7/7/2010)
hi,

Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have access to all details and some don't.

Which would be the best option in this situation (ms access project or database?)

I am new to Sql. I want the easiest method of implementing security.

please help

Thanks in advance


The best way is to define and specify your security settings in the SQL Server.

And then build your front-end MS Access ADP project directly linked to that SQL Server with Windows Authentication.
Post #964497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse