Users vs Owners level rights

[Ramesh]

Hi,

I learnt at some point that it s more secure to set the queries rights at
owners level rather than grant rights to the table itself. and i have been
doing that, but quite blindly.

could someone clarify as to what is the exact benefit of doing this? what i
can see that it limits the extent of change a user can do to the table to
whatever the query will allow. Is there something besides this too?

Thanks
Ramesh

 

[Arvin Meyer [MVP]]

You've got the main reason to secure the tables and grant WITH OWNERACCESS
OPTION to users. In fact, users should never be permitted direct access to
the tables even if they need access to every field. Use a datasheet form, at
the very least, instead. The reasons are:

1. Security - you never see any database admin open the tables in any other
RDBMS.

2. Data integrity - Since Access has no triggers and thus only limited
enforcement of rules at the table level, users must go through forms to
ensure data integrity. With query based forms, Access has even more control
than almost any other RDBMS, because of VBA which can be used both in
queries and in forms.

 

[Ramesh]

Thanks Arvin.

Ramesh

You've got the main reason to secure the tables and grant WITH OWNERACCESS
OPTION to users. In fact, users should never be permitted direct access to
the tables even if they need access to every field. Use a datasheet form,
at the very least, instead. The reasons are:

1. Security - you never see any database admin open the tables in any
other RDBMS.

2. Data integrity - Since Access has no triggers and thus only limited
enforcement of rules at the table level, users must go through forms to
ensure data integrity. With query based forms, Access has even more
control than almost any other RDBMS, because of VBA which can be used both
in queries and in forms.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com