Security Manager: Users list limited to 2 pages

13 views
Skip to first unread message

Raymond Willems

unread,
Oct 19, 2017, 9:17:04 AM10/19/17
to OrientDB
Dear OrientDB-Community,

I only see two pages (e.g. first 20 users) in the list of users in the Security Manager of OrientDB Studio (latest).

Also searching for users is only working for the listed users.

Changing to show 100 results per page doesn't help and also shows only 20 users.

As workaround: Can I change a password in the OUser document? As it is encrypted, how can I enter a new password here?

Best regards,
Raymond

Luigi Dell'Aquila

unread,
Oct 19, 2017, 9:30:04 AM10/19/17
to orient-...@googlegroups.com
Hi Raymond,

I just checked, there is a little bug there.
As a temporary work-around you can just do an 

UPDATE OUser SET password = "xxx" WHERE name = "xxx"

The password will be automatically encrypted. Just make sure to do it with an "admin" user, as other roles do not have the permission to do it

Thanks

Luigi


--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Raymond Willems

unread,
Oct 19, 2017, 9:46:28 AM10/19/17
to OrientDB
Thanks Luigi for the fast response!! This Workaround is fine for now!

Best regards,
Raymond

Raymond Willems

unread,
Oct 19, 2017, 9:51:39 AM10/19/17
to OrientDB
Same problem when using: select * from OUser

Only two pages are shown.

Luigi Dell'Aquila

unread,
Oct 19, 2017, 9:58:01 AM10/19/17
to orient-...@googlegroups.com
By default Studio limits the result sets to 20.
You can change this default clicking on the options (little button next to the yellow "explain", bottom right corner of the query panel) or you can explicitly add a LIMIT -1 to the SQL statement

Thanks

Luigi

2017-10-19 15:51 GMT+02:00 Raymond Willems <sme...@me.com>:
Same problem when using: select * from OUser

Only two pages are shown.

--
Reply all
Reply to author
Forward
0 new messages