Permissions

I'm using Access 2003 and sql 2000. I have a phone data table that has
permissions set for a Users group and a Cell group.
I have created a view for Cell numbers and I want only the Cell group to
access. I've given the Cell group Select permission. But I can't keep the
Users group from accessing the Cell numbers. I've tried to place an X in
Select for the Users group but then no one has access. If I don't do anythin
g
with the Users group then everyone can access the Cell numbers.
Can anyone help with the permission problem?
Thanks,
PaulI'm assuming that the CELL group is also part of the Users group.
If the Users group has permission to SELECT the table, then you cannot
prohibit them from being able to access the Cell Numbers.
One option is to Create a View for the table (without the Cell Numbers),
grant Permission to the Users Group to SELECT from this new view.
Then REMOVE all permissions from the table.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pjscott" <pjscott@.discussions.microsoft.com> wrote in message
news:5B447AF6-DA1F-4B9A-B622-956427901871@.microsoft.com...
> I'm using Access 2003 and sql 2000. I have a phone data table that has
> permissions set for a Users group and a Cell group.
> I have created a view for Cell numbers and I want only the Cell group to
> access. I've given the Cell group Select permission. But I can't keep the
> Users group from accessing the Cell numbers. I've tried to place an X in
> Select for the Users group but then no one has access. If I don't do
> anything
> with the Users group then everyone can access the Cell numbers.
> Can anyone help with the permission problem?
> Thanks,
> Paul|||I've taken all permissions off the table. I already had several views create
d
without the cell numbers. I've set the users group to have Select permission
to the views except the Cell view.
If I set the Select permissions to the Cell view for the Cell group and do
not give or deny permissions to the users group the users group still have
access.
If I place an X in the users group for the Cell view then no one has access.
I thought that if permission wasn't given or denied a group or individual
couldn't gain access.
Have any ideas what I'm doing wrong?
Thanks for the help,
Paul
"Arnie Rowland" wrote:

> I'm assuming that the CELL group is also part of the Users group.
> If the Users group has permission to SELECT the table, then you cannot
> prohibit them from being able to access the Cell Numbers.
> One option is to Create a View for the table (without the Cell Numbers),
> grant Permission to the Users Group to SELECT from this new view.
> Then REMOVE all permissions from the table.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "pjscott" <pjscott@.discussions.microsoft.com> wrote in message
> news:5B447AF6-DA1F-4B9A-B622-956427901871@.microsoft.com...
>
>|||As I mentioned before, are member of the Cell group ALSO members of the
Users group?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pjscott" <pjscott@.discussions.microsoft.com> wrote in message
news:A2A4750C-81D6-4B54-AE1F-5B2EE651190A@.microsoft.com...[vbcol=seagreen]
> I've taken all permissions off the table. I already had several views
> created
> without the cell numbers. I've set the users group to have Select
> permission
> to the views except the Cell view.
> If I set the Select permissions to the Cell view for the Cell group and do
> not give or deny permissions to the users group the users group still have
> access.
> If I place an X in the users group for the Cell view then no one has
> access.
> I thought that if permission wasn't given or denied a group or individual
> couldn't gain access.
> Have any ideas what I'm doing wrong?
> Thanks for the help,
> Paul
>
> "Arnie Rowland" wrote:
>|||Yes. The Users group is really a everyone group. The Cell group is a group o
f
20 people who are also part of the Users group.
Sorry for the misunderstanding,
Paul
"Arnie Rowland" wrote:

> As I mentioned before, are member of the Cell group ALSO members of the
> Users group?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "pjscott" <pjscott@.discussions.microsoft.com> wrote in message
> news:A2A4750C-81D6-4B54-AE1F-5B2EE651190A@.microsoft.com...
>
>|||Since the Cell group is part of the User group, and the User group has full
access to the Table, there is no way to limit the User group from accessing
the cell numbers.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pjscott" <pjscott@.discussions.microsoft.com> wrote in message
news:97020BE8-B1A8-45C4-8028-3A6C3039D690@.microsoft.com...[vbcol=seagreen]
> Yes. The Users group is really a everyone group. The Cell group is a group
> of
> 20 people who are also part of the Users group.
> Sorry for the misunderstanding,
> Paul
>
> "Arnie Rowland" wrote:
>