How do I retrieve a User PID

11 Sep 2006 9:01 PM

Hoo-Mee

I have inherited a group of databases within a domain, where the users and
groups were already set up (long ago, but added to). It appears that users
were not deleted as they left due to a concern as to whether there might be
undocumented databases "out there" which they had sole access to. I want to
clean house, and have read that a user can be reinstated if given the same
user name and PID - but I can't find any means of determining the existing
PID. Is there a way to do this? Is this unnecessary - or does the new user
given the same user name and groups have the same capability anyway? Is
ownership an issue, and can it be assumed by an administrator?

14 Sep 2006 12:22 AM

Joan Wild

Generally users are not given permissions. It is easier to manage security
by granting permissions to groups, and then just putting users in the
necessary groups.

In this case, you don't need to document the username/PID. You can delete a
user, recreate with a different PID and still put them in the necessary
groups.

I suppose it's possible that in your databases, someone granted permissions
to users, so to answer your question, no you can't retrieve the PID.

The owner of the database (this is usually a member of the Admins group) can
take over ownership of any object in the mdb.

--
Joan Wild
Microsoft Access MVP

Hoo-Mee wrote:

Show quoteHide quote

> I have inherited a group of databases within a domain, where the
> users and groups were already set up (long ago, but added to). It
> appears that users were not deleted as they left due to a concern as
> to whether there might be undocumented databases "out there" which
> they had sole access to. I want to clean house, and have read that a
> user can be reinstated if given the same user name and PID - but I
> can't find any means of determining the existing PID. Is there a way
> to do this? Is this unnecessary - or does the new user given the
> same user name and groups have the same capability anyway? Is
> ownership an issue, and can it be assumed by an administrator?

14 Sep 2006 11:51 AM

david

Deleted users can be effectively re-created, as long as you
have the original MDW, and a user who is a member of the
Admins group in that MDW.

If you have the Original MDW, any member of the Admins
group of that MDW can assume or assign ownership, and
can fix up permissions.

Note that this is not the same as having 'admin permission'

(david)

Show quoteHide quote

"Hoo-Mee" <Hoo-***@discussions.microsoft.com> wrote in message
news:A208C11F-F759-4EF9-8D5B-74A3BB4FC35F@microsoft.com...
> I have inherited a group of databases within a domain, where the users and
> groups were already set up (long ago, but added to). It appears that
users
> were not deleted as they left due to a concern as to whether there might
be
> undocumented databases "out there" which they had sole access to. I want
to
> clean house, and have read that a user can be reinstated if given the same
> user name and PID - but I can't find any means of determining the existing
> PID. Is there a way to do this? Is this unnecessary - or does the new
user
> given the same user name and groups have the same capability anyway? Is
> ownership an issue, and can it be assumed by an administrator?