# Login password read

**URL:** <https://community.passbolt.com/t/login-password-read/5879>\
**Category:** Community Feedback\
**Created:** [September 29, 2022, 12:56pm UTC](https://community.passbolt.com/t/login-password-read/5879 "2022-09-29T12:56:20Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![AnatomicJC](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/anatomicjc/32/962_2.png) [@AnatomicJC](https://community.passbolt.com/u/AnatomicJC)\
**Post date:** [September 29, 2022, 3:02pm UTC](https://community.passbolt.com/t/login-password-read/5879/5 "2022-09-29T15:02:41Z")

</div>

Hi 👋

All passbolt actions are logged in action\_logs, even in the CE version.

You can get a list of passwords accessed by a user with this SQL request:

```auto
SELECT
       al.created,
       u.username,
       r.name,
       r.uri,
       r.deleted
FROM
       action_logs al
       INNER JOIN actions a ON al.action_id = a.id
       INNER JOIN users u ON u.id = al.user_id
       INNER JOIN secret_accesses sa ON sa.created = al.created
       INNER JOIN resources r ON sa.resource_id = r.id
WHERE
       a.name = "ResourcesView.view";

```

Another request example, if you want to search all actions made between last september 14th and 15th:

```auto
SELECT al.created AS Datetime, u.username AS Username, a.name AS ActionName, al.context AS Context
FROM action_logs al 
JOIN actions a on a.id = al.action_id
JOIN users u on u.id = al.user_id
WHERE al.created > "2022-09-14 00:00:00" AND al.created < "2022-09-15 00:00:00"
ORDER BY al.created asc;

```

Best,

---

_[View the full topic](https://community.passbolt.com/t/login-password-read/5879)._