[AccessD] A97 User Security

MartyConnelly martyconnelly at shaw.ca
Thu Dec 23 11:00:57 CST 2004


Ooops I guess you need the URL
http://accesstools.narod.ru/index.html

Mark A Matte wrote:

> Thanks Jim.
>
> Do you know if the www.lostpassword.com utility will work if I don't 
> have the original MDW?
>
> 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 17:31:12 -0500
>>
>> 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
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list