Follow

How can I find all the Vaults a user owns?

When you have an employee leave, or perhaps no longer needing access to Vaults we can find out the exact Vaults the user owns. 

If you access the Password Server SQL Database via SQL Management Studio > AuthAnvilPasswordServer > Tables >  dbo.UserTable you will be able to confirm the UserID.

pws.PNG

Now that we know the UserID we can view dbo.VaultTable to find out what the Vault ID's are.

pws2.PNG

With the VaultID and UserID known we can now compare this information with dbo.VaultMemberTable

pws3.PNG

 

As you will now see after reviewing these three tables we can determine that User ba@scorpionlabs.com UserID 3 is a member of VaultID 3. 

Now we simply access VaultID 3 Acme Passwords and remove the users ownership of the Vault.

Access the Password Server > Vaults > Specific Vault (Acme Passwords) > Manage Vault > Current Members - remove Ownership permissions from the user.

pws4.PNG

Select Save Changes. This will remove the chosen user from Ownership and allow you to remove the user.

 

Questions?

If you have any questions or need some help, we would be happy to assist. Open a case at help.scorpionsoft.com or send an email to support@scorpionsoft.com.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk