How do I retrieve a User PID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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)
 
Back
Top