As an admin I can audit passwords that are not shared with anyone

Feature requests
,
4

I believe the following mysql query will show all passwords which are not shared, and therefore are only accessible by a single user:

mysql> select r.id, r.name, u.username, p.type from resources r
       join permissions p on p.aco='Resource' and p.aco_foreign_key=r.id
       join users u on p.aro='User' and p.aro_foreign_key=u.id where r.id in
       (select resource_id from users_resources_permissions group by resource_id having count(*) < 2);

@SteveDrakey:

We would like an auto share feature which I guess gives the same result. We don’t want user x to create a password for client y and then go on holiday and we have a problem and we cannot access the passwords for the client.

Related issues: