Add users to group by SQL caommand

When you make any changes in database level you need to COMMIT the changes in order to see it reflect in the IEE. You can simply add following line of code below your insert statement to do this. otherwise you can use commit icon available in the database tool you are using.

COMMIT ; 

As @david.harmer has posted, you should never insert or update directly into the core IFS tables, unless you have a very specific reason to do so.  You risk breaking data integrity from bypassing all the core business logic.

You need to understand what you are trying to do technically in the system first, use the debug console to figure out what the underlying database methods are being invoked.  Then you could use data migration or a PLSQL script if necessary, but always call the core new or modify methods for the relevant logical unit.

What is the screen in the IEE client you are reffering to after inserting a record directly in the database? Maybe there is a where condition from the client-side to filter out certain data