Re: hide SOME query results for unauthorized users

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


I presume you have some kind of login procedure, perhaps even with password
protection, and you have a table of Users and Login info. Include the tag
info (organizational position?) in the Users table. Include join of these
tables in the query and return only those matching User Login ID. Is your
project set up to open to particular form and has menus and shortcuts (right
click) disabled?

Derek wrote:
how can I restrict access to records marked confidential or sensitive? Some
of the data in my DB is to be viewed only by personnel with specific
permission, and not the general population. I think I know how I could "tag"
a record as being available to permission holders, but how can I keep the
data in the record from being viewed by users without that permission?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200906/1

.

Relevant Pages

  • Re: hide SOME query results for unauthorized users
    ... and you have a table of Users and Login info. Include the tag ... tables in the query and return only those matching User Login ID. ... permission, ... I think I know how I could "tag" ...
    (microsoft.public.access.queries)
  • Re: How to display the "Access Denied" page directly without the a
    ... authentication on whatever the link is pointing to. ... say "it is Shareponit's default behavior to pop up that login box ... whenever user tries to access the sharepoint page to which he/she does ... not the permission", I am referring to the Sharepoint access ...
    (microsoft.public.sharepoint.portalserver)
  • I was the owner of the access database. and now the owner is unkow
    ... that I don't have the necessary permission. ... Every once and while the login ... Microsoft Access MVP ... cut Access opens and I immediately get the message that I dont have ...
    (microsoft.public.access.security)
  • Re: Allowing Anonymous write access only.
    ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Windows authentication still prompts for database login
    ... would expect the reported type to be "user" and the permission path to be 'MyDomain\WindowsGroupName' if the user account was specified. ... Did you perhaps specify the group account name instead of the user account name as the first xp_logininfo parameter? ... login name SID DefDBName DefLangName Auser ARemote ... -- this line reports "Could not obtain information about Windows NT group/user 'crestlinecoach\domain users'" ...
    (microsoft.public.sqlserver.security)