Removing MDW security

[Salad]

If a person has a MDB secured with user-level security that uses an MDW,
what steps does one take to fully remove the user-level security.

[Tom van Stiphout]

On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

It's in the Security FAQ available on microsoft.com:

34. How can I "de-secure" a database?
You must have Administer permissions and/or be a member of the Admins
group in the workgroup information file that the database was secured
with. Grant full permissions to the Users group and the Admin user
account. Put the Admin user back in the Admins group and remove the
password from the Admin user. You will not be prompted for a logon ID
and password once the password is removed from the Admin user.
Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.

-Tom.

>If a person has a MDB secured with user-level security that uses an MDW,
what steps does one take to fully remove the user-level security.

[Keith Wilby]

"Tom van Stiphout" <to*************@cox.netwrote in message
news:oa********************************@4ax.com...

On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.

And if you'd rather not run the wizard (and who would want to? ;) ) then, as
a final step, import all objects into a new blank mdb file.

Keith.
www.keithwilby.co.uk

[Salad]

Keith Wilby wrote:

"Tom van Stiphout" <to*************@cox.netwrote in message
news:oa********************************@4ax.com...

>On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oi*@vinegar.comwrote:

Optionally, you can also run the Security Wizard again to transfer
ownership of all objects back to the Admin user, but the wizard will
also remove permissions from the Users group, which you may not want.

And if you'd rather not run the wizard (and who would want to? ;) )
then, as a final step, import all objects into a new blank mdb file.

Keith.
www.keithwilby.co.uk

Thank, Keith and Tom