Re: Security without signon
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 13:14:41 -0500
I am thinking that you didn't create a new workgroup file to secure it with.
That is still a requirement.
Create a new workgroup file; secure it, but grant limited permissions to the
Users Group. Distribute the mdb without your workgroup file.
--
Joan Wild
Microsoft Access MVP
BPH wrote:
> OK, I have changed the owner of the database and the tables to a user
> (my user id). As an added precaution, I created a new (non-default)
> admin group called SBAdmin and assigned full rights to the tables to
> this group and removed all table rights from the default Admins group.
>
> However, users are still able to link to the tables with full rights.
> Further, if they open the database (I temporarily allowed
> Shiftkeybypass for testing purposes) they have full rights to the
> tables as well. The user is using their default security.mdw file
> but seems to gain access to the tables via the Admins group (all
> rights are checked for this group, but not checked for the user Admin
> or for the group Users), despite the fact that I have explicitly
> removed table access from the Admins group. Is there something I
> have to do to ensure my access changes take effect?
>
> Thanks for your continued help.
>
> "Rick Brandt" wrote:
>
>> BPH wrote:
>>> Thank you Rick, That works except that when trying to limit users
>>> from being able to link to the tables in my database, the users are
>>> not restricted. I have not split my database (FE/BE) and at this
>>> point would prefer not to. I have set up the form to run off a RWOP
>>> query, and I have removed all access to the tables from the Users
>>> Group. I have put the database on a network drive and have not put
>>> the security.mdw file with it, thus users are not prompted for a
>>> password. I would expect that any user linking to the database from
>>> another database would be stopped by not having sufficient rights
>>> inherited from the Users group (I have removed the Admin user from
>>> the Admins group). But users are able to link to the table with
>>> full rights. Any thoughts???
>>
>> Does the default user "Admin" own the database ir any of the objects
>> within? Owners have rights above and beyond those that are
>> explicitly granted to them.
>>
>> --
>> I don't check the Email account attached
>> to this message. Send instead to...
>> RBrandt at Hunter dot com
.
- Prev by Date: Re: Security without signon
- Next by Date: Re: password Protecting Switchboard Items
- Previous by thread: Re: Security without signon
- Next by thread: Re: Security without signon
- Index(es):
Relevant Pages
|
Loading
