Users vs Owners level rights

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh - 28 Mar 2007 14:00 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 28 Mar 2007 15:23 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks
> Ramesh

Reply to this Message

Ramesh - 31 Mar 2007 11:09 GMT

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
[quoted text clipped - 23 lines]
>> Thanks
>> Ramesh

Reply to this Message