How to set a table to have 'update' privilege but not 'read' privilege

  • Thread starter Thread starter mpfohl
  • Start date Start date
M

mpfohl

I have a secured database. Every time the user logs into the
database, their user name and time of log in is recorded to a linked
table associated with another database (also with user level
security). This system is working fine.

Is there a way I can set up the 'user login table' in the separate
'user login database', so that users can add to that table (i.e. their
info is automatically appeneded to the current list via my VB code
when they log in) BUT, if they try to open the table, they can't see
the data? In other words, they can't see the record of who logged in
when if they try to open that table.

I tried setting user permissions in the security area to allow users
without admin privileges to only insert data to the table, but then it
automatically grants them 'read' permissions to the table as well.

I think I'd like the table to behave for users like a form that is
opened in 'add mode', where the only record viewable is the current
one being added. Is there a way to set that up?

Thanks
 
Use an RWOP (run with owner permissions) query to do the append. Then users
don't need any permissions on the underlying tables at all.

You'd just run the RWOP query in code. Users will need update permission on
the query.

Read more about RWOP at www.jmwild.com/RWOP.htm
 
thanks

Use an RWOP (run with owner permissions) query to do the append. Then users
don't need any permissions on the underlying tables at all.

You'd just run the RWOP query in code. Users will need update permission on
the query.

Read more about RWOP atwww.jmwild.com/RWOP.htm

--
Joan Wild









- Show quoted text -
Click to expand...
 
Back
Top