Connecting Tech Pros Worldwide Forums | Help | Site Map

Security Wizard but Not Secure

drink.the.koolaid@gmail.com
Guest
 
Posts: n/a
#1: May 16 '06
Hello people.

I have a database that:
* was not secured originally
* I applied the user-level security wizard to
* has the Admin user demoted to the Users group
* had the User's group with no permissions
* the Admin user doesn't own any objects

When I open this with my shortcut and new mdw file everything works as
expected.
When I open this with standard Access security.mdw, my database is
still wide open.

Any ideas what step I missed?

Thanks


Keith Wilby
Guest
 
Posts: n/a
#2: May 16 '06

re: Security Wizard but Not Secure


<drink.the.koolaid@gmail.com> wrote in message
news:1147781112.258494.175040@i39g2000cwa.googlegr oups.com...[color=blue]
> Hello people.
>
> I have a database that:
> * was not secured originally
> * I applied the user-level security wizard to
> * has the Admin user demoted to the Users group
> * had the User's group with no permissions
> * the Admin user doesn't own any objects
>
> When I open this with my shortcut and new mdw file everything works as
> expected.
> When I open this with standard Access security.mdw, my database is
> still wide open.
>
> Any ideas what step I missed?
>[/color]

Possibly more than one, it's easily done. Have you removed the "Users"
group's permission to the *database* object? The problem with the wizard is
that you don't learn anything about user-level security which is
self-defeating IMO. Have you read the security FAQ (link on my web site)?

Regards,
Keith.
www.keithwilby.com


Closed Thread