Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Hide objects dynamically per user

    In setting up a shared db, how does one go about hiding the objects for which the user does not have any privileges?

    Am trying autoexec, hidden property, and "usys" prefix to object names, permissions via DAO, containers... am a little lost and unsure whether this it the right direction. Haven't found anyone else talking about it.

    Thanks, in advance.

    How would I return the state after the user closes?

  2. #2
    Join Date
    Feb 2004
    Location
    Houston, Texas
    Posts
    45
    Have you looked at Tools/Security/User & Group Permissions menu? Then for more details look at the help under Security.
    rtk

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Look up StartupShowDBWindow , AllowSpecialKeys , AllowFullMenus and more

  4. #4
    Join Date
    Feb 2004
    Posts
    2
    I do this with all my databases. I am not sure if this is the best or most efficient way to do this, but it works for me.
    First you need to get the user's windows logon, then set up a table for security settings, then in your code say that if the windows logon = a specific security setting then fieldA.visible = True (or false).

    for my security table I have window's logon's, username, and the security setting. So if user A is a director she has access to everything, versus a low man on the totem pole has access to only one or 2 fields. Based on the security setting in that table you can make certain fields visible or not visible.

    Hope that helps.

  5. #5
    Join Date
    Mar 2004
    Posts
    6

    Using groups instead

    With a little thought and help from a collegue I've gone back to just helping users see their tables via Groups, which will work for my purpose. The security table sounds like a good idea since this is a db that doesn't have a public interface.

    Thanks, ya'll for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •