Identify User Membership in SQL Server

In production environment, users membership can get complicated due to nested user groups. The following query gives an overview of the mapping of all users and user groups. Here is a sample result. Please note, this result has unfolded all the nested user group relationship.

Add Script to Kepion Default Web Page

You can enter a custom script to the Kepion default webpage (e.g. set up Google Analytics tracking) by using the Web Page->HEAD module.  Include your script by typing into the HEAD text box and click Save.  For example: Once saved, you can hit F5 to reload the page in IE.  … Read More


You can now limit access to certain regions within the MODELER and ADMINISTRATOR module by user.

Manage Security from SQL Server Management Studio

Kepion allows you to configure security through Kepion Administrator UI or SQL Server Management Studio. This article will walk you through the relationship tables that are related to security settings. In Security -> Membership, you can add user/user group/role to a role. In the database, the [dbo].[UserAffiliations] will be … Read More

Activity View on Planning Users

You can create a view in the database to show plan submission status and user actions on the submission. Below is a sample definition of the view.  You can modify it as needed. This is the result you will see when selecting from the view.