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.
what steps does one take to fully remove the user-level security.
-
-
Re: Removing MDW security
On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oil@vinegar.co mwrote:
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. -
Re: Removing MDW security
"Tom van Stiphout" <tom7744.no.spa m@cox.netwrote in message
news:oahdf4dtlh a1mj64sggprrmgr apimokh7k@4ax.c om...And if you'd rather not run the wizard (and who would want to? ;) ) then, asOn Wed, 15 Oct 2008 20:02:34 -0700, Salad <oil@vinegar.co mwrote:
>
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.
>
a final step, import all objects into a new blank mdb file.
Keith.
Comment
-
Re: Removing MDW security
Keith Wilby wrote:
Thank, Keith and Tom"Tom van Stiphout" <tom7744.no.spa m@cox.netwrote in message
news:oahdf4dtlh a1mj64sggprrmgr apimokh7k@4ax.c om...
>>>On Wed, 15 Oct 2008 20:02:34 -0700, Salad <oil@vinegar.co mwrote:
>>
>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
Comment
Comment