RECORD LEVEL SECURITY

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is it possible to restrict access to records for users. I want them to only
see their own records and not the records of others.

If so would you be able to give me some insight on how you would do that?
 
Well, you could use a query with an appropriate WHERE clause to restrict
rows to only which users are authorized to view/edit.

That will work for keeping honest users honest but if you need something
more than that, I would probably look for a RDBMS backend. With .mdb
format, you have the option of using ULS and running RWOP queries so it
can't be easily edited and requires more technical expertise but ULS &
RWOP queries still could be overcome, hence me suggesting a RDBMS
backend first.
 
Access, or rather, Jet is an RDBMS. I think what you are referring to is a
server database engine rather than a file database engine. If internal
security is crucial, a server based system, like SQL-Server, is imperative.

That said, if you have any reason not to trust a user, they shouldn't be
working for you. Regardless of whether or not they can get into a database,
untrustworthy users have no place in a company.
 
That is very helpful. Thank You Banana

Banana said:
Well, you could use a query with an appropriate WHERE clause to restrict
rows to only which users are authorized to view/edit.

That will work for keeping honest users honest but if you need something
more than that, I would probably look for a RDBMS backend. With .mdb
format, you have the option of using ULS and running RWOP queries so it
can't be easily edited and requires more technical expertise but ULS &
RWOP queries still could be overcome, hence me suggesting a RDBMS
backend first.
Click to expand...
 
Bob said:
Is it possible to restrict access to records for users. I want them to only
see their own records and not the records of others.

If so would you be able to give me some insight on how you would do that?
Click to expand...
 
Back
Top