What are the minimal set of Microsoft SQL permissions the database user needs in order to be able to do all one needs for the end users of SBM? For information about Oracle permissions , see KB S133641 .
What are the minimum set of Oracle permissions needed for the schema in order to use SBM? For information about Microsoft SQL permissions , see KB S138590 .
below. Also, note that if the user closes the browser in an SBM version older than 11.4, then the license release will not be triggered. Only the exit link in the UI will trigger the license release for versions prior to SBM 11.4[2 ]
that following versions of SBM ( 11.4.2 and 12.0) can be manually updated to log4j 2.17 using the following steps. Versions likely can be updated with some customer reports of success on 11.8 and 11.7.1, but have not been officially tested yet. If you find this does not work for your system, then return the original JAR files to their location and back out the changes.
In order for SBM to work correctly all its tables must be owned by dbo. If you look in MSSQL Enterprise Manager and you see any tables without the syntax of dbo.TS_USERS for example run the following sql against the database in question.
The following document lists the various databases used by SBM and the indexes that are created by default. You can compare the indexes you currently have to these or if you run the sql to create them they will get inserted unless they already exist then they will just give and error and get skipped.
If this value has never been set, the database record will have a NULL in the value. (NOTE: The only way to make this NULL after it has been set is to update it directly via database SQL command. It cannot be done from SBM.) When the system sees the NULL value, it will check the setting inside of the SBM System Administrator (Start > Programs > Serena > SBM System Administrator) under Options > Settings > Locale.
