Re: Permissions to allow creation of forms etc?
- From: "JZ" <jj@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 07:34:08 -0000
Hi,
Thanks so much for your help.
I'm not using the admin account.
I've limited the admin user and admins group.
Created a new database from the logged in super user.
Then as the super user / database owner from the new database removed most
permissions.
This was based on the instructions from SecFaq.
This works fine if I'm access the database from a VB program, where I just
have tables etc.
But I'm trying to provide some user security for access developers.
(I guess I'll also need to add a normal user without privileges too.)
So I'm adding as few permissions as possible.
I looked and I already can see system objects.
When I open any of the system tables I can see the records, values but I can
alter any of the data.
I'm guess this must be the problem?
What permission do I need for that?
Best regards,
Jules.
.
- Follow-Ups:
- Re: Permissions to allow creation of forms etc?
- From: Frank Hickman [MVP]
- Re: Permissions to allow creation of forms etc?
- References:
- Permissions to allow creation of forms etc?
- From: JZ
- Re: Permissions to allow creation of forms etc?
- From: Frank Hickman [MVP]
- Re: Permissions to allow creation of forms etc?
- From: JZ
- Re: Permissions to allow creation of forms etc?
- From: Frank Hickman [MVP]
- Permissions to allow creation of forms etc?
- Prev by Date: Re: Permissions to allow creation of forms etc?
- Next by Date: Re: ADO Connection - Fails - Unspecified Error
- Previous by thread: Re: Permissions to allow creation of forms etc?
- Next by thread: Re: Permissions to allow creation of forms etc?
- Index(es):
Relevant Pages
- Re: User Level Security Malfunction
... menu, the Users group has no rights to open the database, and it also ... I
first create a blank secured file that I ... Remove Admin from Admins group ...
Remove all permissions to "new" objects from Admin ... (microsoft.public.access.security) - Q: low permission cannot convert from A97 to A2000/2003
... A97, but the database is sent out and used by contractors (user permissions)
... The admin user has full privileges. ... The problem we are having is converting
the database from A97 to 2000+. ... (microsoft.public.access.security) - Security Wont work
... I have set up a database and created a workgoup file. ... the admins group
so admin is only a member of the user ... All permissions for the user group are turned
off. ... I see in Snelling's security document that there are two ... (microsoft.public.access.security) - Exclusive locks
... When I secured the database, I created two new users, ... "Full Permissions"
and "Full Data Users." ... groups Full Permissions and Users (the users "Admin" and "Staff"
are exactly ... Why isn't Access able to obtain the exclusive lock that it's apparently
... (microsoft.public.access.security) - Re: Sorting out security
... > MS Access security. ... > created a new workgroup, added a password
for the Admin role, added ... > remote logins to a secured database. ...
The location of the current workgroup file is recorded in the ... (microsoft.public.access.security)