Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Security in Multiuser environment (Ms Access Project or Ms access database)


Security in Multiuser environment (Ms Access Project or Ms access database)

Author
Message
kiranmai.gompa
kiranmai.gompa
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
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
radekhatle
radekhatle
SSC Veteran
SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)SSC Veteran (235 reputation)

Group: General Forum Members
Points: 235 Visits: 251
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...
dschubel
dschubel
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 1454
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.
Uripedes Pants
Uripedes Pants
Say Hey Kid
Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)Say Hey Kid (707 reputation)

Group: General Forum Members
Points: 707 Visits: 4519
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.
Rayis Imayev
Rayis Imayev
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 273
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search