[AccessD] A97 User Security

Mark,

<<Thanks for the feedback...but there are no passwords on this db...>>

 Understood.  There are various utilities out there, some work on the
database password while others work on the workgroup file.  You need the
later.

<<There are only 2 workgroups...Admins and Users...I belong to both...but
don't have permission to change anything.  I can't even view the permission
settings of the groups.  I'm guessing there was another workgroup...>>

  Yes.

<<that has been removed?>>

<<Is this possible?>>

<<I've always used my own security...and
never the built in...I'm not sure how they created it with no one having the
authority to change anything?>>

  You would if you had the workgroup file that had the correct SIDs.  In in
the past, I've setup some DB's with exactly this setup.  For development, I
have one MDW.  For the clients, they just use the standard MDW file.

  This is possible because the user 'Admin' and the group 'users' have the
same SID (Security ID) no matter what MDW file you use.  The group 'admins'
however, is different for each one.

  So in your case, ownership of the objects belongs to someone that was in a
different admins group, but the ability to run, view, etc was assigned to
the users group (which is the same no matter which MDW you use).

  You need to break user level security and www.lostpassword.com does have a
utility for that.

Jim Dettman


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Wednesday, December 22, 2004 11:49 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] A97 User Security


Thanks for the feedback...but there are no passwords on this db...I have my
own app that returns the database password...which the one mentioned below
does...in addition to the user level stuff.  The problem is there are no
passwords(database or user level) in this db...and thats what this tool said
also.  But I still can't figure out how to modify permissions.

Any ideas?

Thanks,

Mark



>From: "Jim Dettman" <jimdettman at earthlink.net>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] A97 User Security
>Date: Wed, 22 Dec 2004 07:19:12 -0500
>
>Mark,
>
>   Since it's user level security that's at play here, you'll need a
>utility.
>www.lostpassword.com  is one site that offers such a utility.  Do a Google
>search on "access" "password" and you'll turn up a bunch.  There are a few
>Russian sites that have them for free.
>
>Jim Dettman
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
>Sent: Tuesday, December 21, 2004 3:16 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] A97 User Security
>
>
>Hello All,
>
>I'm pretty sure this is a lost cause...but I just received an A97
>db...there
>is no password...but I don't have permission to make any
>changes(tables,queries...or even view the macros).  My guess is I need to
>know the UserGroup and PID that was used to change/create the permissions.
>Is this correct...and are there any workarounds?
>
>Thanks,
>
>Mark
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com