+ Reply to Thread
Results 1 to 4 of 4

Removing MDW security

  1. Removing MDW security

    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.

  2. Re: Removing MDW security

    On Wed, 15 Oct 2008 20:02:34 -0700, Salad wrote:

    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.


  3. Re: Removing MDW security

    "Tom van Stiphout" wrote in message
    newsahdf4dtlha1mj64sggprrmgrapimokh7k@4ax.com...
    > On Wed, 15 Oct 2008 20:02:34 -0700, Salad wrote:
    >
    > 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


  4. Re: Removing MDW security

    Keith Wilby wrote:

    > "Tom van Stiphout" wrote in message
    > newsahdf4dtlha1mj64sggprrmgrapimokh7k@4ax.com...
    >
    >> On Wed, 15 Oct 2008 20:02:34 -0700, Salad wrote:
    >>
    >> 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

+ Reply to Thread