In the mean time we have around 140 users with 16 roles in our application. To improve the administration we created a SQL query. The query works perfect to see the user-role assignments. But as soon as we want to change the assignments with SQL, it does not work properly. We always have to re-start the server.

asked 27.01.2010 at 02:48

Steffen%20Janthor's gravatar image

Steffen Janthor
accept rate: 0%

First a warning: Do NEVER write directly into the System DB unless you know exactly what you do! In the worst case you can destroy your Ivy installation.

The Xpert.ivy server uses internal caches of the data from the System DB to optimize its performance. If you write directly into the system DB, then the server does not know this and returns the values still from its caches. There is no way to flush these caches externally.

For changes like you want, please use the features we offer by the Public API, in your case from interfaces like IRole and IUser.


answered 27.01.2010 at 09:34

Christian%20Strebel's gravatar image

Christian St... ♦
accept rate: 88%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 27.01.2010 at 02:48

Seen: 2,130 times

Last updated: 27.01.2010 at 02:48