Permissions Help

2 Jul 2006 10:16 AM

Ian

I'm just getting to grips with security for my db app, which is for the
doctors in my hospital. I've set security up with an Admin group that only
I'm in to administer the db. I have a second group, Consultants so the senior
doctors can you the db and have permission to everything except
administration activities. The last group is JuniorDocs, which is for the
junior doctors to simply enter data. I don't want to allow them to be able to
search the db or view reports. I still have the Users group but based in
previous help on this forum I've remvoed all permissions from this group and
don't use it per se. In my JuniorDocs group I cleared out all permissions
then gradually introduced permissions to try and achieve my goal. So, they
have Database Open/Run, Tables (All) Read Data/Read Design and Insert Data on
tables that are used for data entry, Forms Open/Run on only those forms that
are linked to tables requiring data entry and Reports No Permissions. When I
run the app as a user from JuniorDocs group, I can open forms that I have not
set permissions. One form, a searching form, generates a separate form with
the search results and has a button to display these results in a report.
Whilst the report won't open it gives an error message with a button to
Debug. I really don't want this being presented to my users as they can start
playing around with the code. I hope I've explained OK, but basically I want
to limit access to this group to only data entry and not present the user
with the error message box that has the Debug button.

Can anyone help,

Thanks,
Ian.

2 Jul 2006 9:01 PM

Ian

In hindsight, perhaps I have rather disguised my question. In my FE db I have
a number of forms that I have not set any permissions on but I can still open
when logged in as an ordinary user. Yet on the only report I have which again
I have set no permissions, if I try and access it through my app I get an
error message which includes a DEBUG button (dangerous!). If I try and open
the report from the Db window the message just says I don't have the
necessary permissions.

Can anyone help me understand.

Ian.

Show quoteHide quote

"Ian" wrote:

> I'm just getting to grips with security for my db app, which is for the
> doctors in my hospital. I've set security up with an Admin group that only
> I'm in to administer the db. I have a second group, Consultants so the senior
> doctors can you the db and have permission to everything except
> administration activities. The last group is JuniorDocs, which is for the
> junior doctors to simply enter data. I don't want to allow them to be able to
> search the db or view reports. I still have the Users group but based in
> previous help on this forum I've remvoed all permissions from this group and
> don't use it per se. In my JuniorDocs group I cleared out all permissions
> then gradually introduced permissions to try and achieve my goal. So, they
> have Database Open/Run, Tables (All) Read Data/Read Design and Insert Data on
> tables that are used for data entry, Forms Open/Run on only those forms that
> are linked to tables requiring data entry and Reports No Permissions. When I
> run the app as a user from JuniorDocs group, I can open forms that I have not
> set permissions. One form, a searching form, generates a separate form with
> the search results and has a button to display these results in a report.
> Whilst the report won't open it gives an error message with a button to
> Debug. I really don't want this being presented to my users as they can start
> playing around with the code. I hope I've explained OK, but basically I want
> to limit access to this group to only data entry and not present the user
> with the error message box that has the Debug button.
>
> Can anyone help,
>
> Thanks,
> Ian.

3 Jul 2006 9:37 AM

Keith Wilby

"Ian" <I**@discussions.microsoft.com> wrote in message
news:409272D8-A0BA-480E-8631-2D119EB88933@microsoft.com...

Ian,

I don't see "FAQ" in your posting, have you read it? It is essential
reading if you want to understand security. There's a link to it on my
website along with my step-by-step example. Also search on here for Jeff
Conrad who also has some very useful links.

Keith.
www.keithwilby.com

3 Jul 2006 5:48 PM

Ian

Hi Keith,

Sorry should have mentioned that, I have read the FAQs a number of times and
I do pick up more each time, but I'll re-read it just in case I've missed
something.

Ian.

Show quoteHide quote

"Keith Wilby" wrote:

> "Ian" <I**@discussions.microsoft.com> wrote in message
> news:409272D8-A0BA-480E-8631-2D119EB88933@microsoft.com...
>
> Ian,
>
> I don't see "FAQ" in your posting, have you read it? It is essential
> reading if you want to understand security. There's a link to it on my
> website along with my step-by-step example. Also search on here for Jeff
> Conrad who also has some very useful links.
>
> Keith.
> www.keithwilby.com
>
>
>