1 Reply Latest reply on Jul 8, 2013 9:58 AM by philmodjunk

    Set Passwords and Access

    gjbrewer

      Title

      Set Passwords and Access

      Post

           I've created multiple User accounts with multiple access levels and passwords. Im now trying to require a password to pop up if someone trys to access info from a certain table.  We store sensative info and I don't want everyone in my office to  have access to info within this table. To be specific:

           - I want each user to require a password upon entry into the database. (already setup)

           - I want each user to be able to browse freely throughout the database so they can enter and lookup data. (Already Setup)

           - I want each user to require a password when trying to access data from one specific Table. (Need Help Setting Up)

            

           Thanks

                      
                     Preferences
      §
      1
      2
      3
      4
      5
      6
      7
      8
      9
      0
      -
      =
      Backspace
                           
      Tab
      q
      w
      e
      r
      t
      y
      u
      i
      o
      p
      [
      ]
                                
      Return
                                
                           
      capslock
      a
      s
      d
      f
      g
      h
      j
      k
      l
      ;
      '
      \
                           
      shift
      `
      z
      x
      c
      v
      b
      n
      m
      ,
      .
      /
      shift
                           
                                
                               English
                                     
                                     
      alt
      alt
                           
                      
                     Preference

            

        • 1. Re: Set Passwords and Access
          philmodjunk

               Wouldn't it be simpler just to refuse access to that table unless the user's account has a particular privilege set or one of a set of privilege sets than to have it ask for an additional password?

               That said, if you remove the layout(s) that show data from that table from the layouts drop down in the status tool bar ( or keep it hidden and locked at all times), you can set up buttons that go to those layouts that use the Show Custom DIalog and a password formatted input field to ask for a supplementary password.

               Other options are also possible.