Re: Adding Permissions to custom security setup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Tony,

Thanks for the input. After setting up the tables, how would I go about
writing code to grant access based on the specific Boolean values
assigned to a particular User.

Since at this point the security component would be driven by Access
itself, from within the tool it brings added complexity since I am not
incorporating Network IDs are part of the Login process.

Users just look up their name in a drop down menu or enter it and enter
their password, (the password is stored along with the related user
name in a separate "Security" table.

A simple validation script checks the password using DLookup again the
correllating values in the "Security" table. At the moment this is my
entire security config. I would like to add permissions to it to
further strengthen this component of my app

Any thoughts are appreciated.
Marc


TonyT wrote:
Hi Kane,

I use something like this in one of my programmes and it works just fine, I
have a 3 tables set-up, Employees table, Access level table
(view/edit/delete/edit this list etc) 10 different levels, and a 3rd table
User Access, which acts as a link table with a child field from the other 2
tables and a boolean yes/no for permission on each level.
Splitting into 3 tables makes it easy to add different levels at a later
date should you require it.
Then I have a further table which is un-linked and randomly named with the
password data *encrypted* in it by a simple algorithm, just to make it
slightly harder for casual prying eyes to determine other passwords.

Having said all that, this programme is for small businesses that are after
particular things, providing security against rogue employees is not high on
their agenda, useability and simplicity is.

Plus it's always worth remembering that the data that they are storing is
theirs and theirs alone.

TonyT..

"Mr.Kane" wrote:

I have an access tool with a simple login form.

There is a "Security" table associated to the form with User_Name and
Password.
(fairly simple approach, but effective based on my users)

I am interested in attributing permissions to each user in this
"Security" table
Admin, Update (Add, Edit, Read) and "Ready-Only"

Any suggestions would be appreciated.


-M



.

Relevant Pages

  • Re: Security Exeception during upgrade
    ... permissions, not just a lack of CAS permissions. ... > by the security policy. ... > Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) ... > System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ClickOnce Nightmares
    ... Expand "Runtime Security Policy" tree node ... Fitim Skenderi ... FileAccess access, Boolean asyncHint) ... all except that on install it runs ...
    (microsoft.public.dotnet.framework)
  • Re: ClickOnce Nightmares
    ... Expand "Runtime Security Policy" tree node ... subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification ... FileAccess access, Boolean asyncHint) ... all except that on install it runs ...
    (microsoft.public.dotnet.framework)
  • Re: DCOM and C# issue
    ... > - a server running on Windows 2000 Server ... > There is a DCOM component located on the server. ... > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ... > security is explicitly managed in C++ (thanks to the CoInitializeSecurity ...
    (microsoft.public.dotnet.framework.interop)
  • VS.NET application security when starting Application from network
    ... The challenge we've faced is .NET Security. ... Request for the permission of type ... StackCrawlMark& stackMark, Boolean isPermSet) ... subkeyName, Boolean subKeyWritable) ...
    (microsoft.public.vsnet.general)