Sharing Schema Items Among Users

In Plexus, certain schema items belong to individual users. Such items are:

  • database views (such as grid views or form views),

  • saved queries,

  • saved lists.

The owner (originally, the creator) of such an item can give the ownership over the item to any other user. This can be accomplished from the Instant JChem desktop application (IJC). In order to give the ownership of one of your database views to another user, right-click on the view node in the IJC project window and select the "Give ownership..." option from the context menu. In the dialog, you can specify the user to whom you want to give the ownership. Please note that after that, this database view will not be available for you except if it is shared with a user group which you belong to. The same procedure can be used to change the owner of a saved query or a saved list. In this case, you have to open "Lists and queries" window of IJC, right-click on the node of the query or list and select the "Give ownership..." option from the context menu.

Database views, lists, and queries can also be shared among users or user groups. You can do this by using one of the following two solutions:

  1. The first possibility is to share items among users based on the different roles assigned to them. With this solution, the shared item will be visible for every user who has the specified role. However, these users will not be able to modify the shared item in any way, only the owner of the item has the privilege to do modifications on it. On the other hand, any changes done by the owner of the shared item will become visible for every other user with whom this item shared after the user's next log-in. You can learn more about sharing schema items in the Instant JChem User Guide.
    Using Instant JChem, you can configure an arbitrary number of user roles to make access to your database more flexible. You can find a detailed description about defining new user roles in the relevant part of the IJC Administrator Guide.
    Please note that IJC defines four user roles by default to control the operations a user can perform. A user can have any of these four roles (even more than one of them), but you have to make user that each user has at least one of these roles assigned to them:

    • ROLE_ADMIN

    • ROLE_EDIT_SCHEMA

    • ROLE_EDIT_DATA

    • ROLE_USER

  2. Another solution can be to make the current user's own copy of a database view, list or query. Once copied, the new item will be completely independent from its original counterpart: any change in either of them will not make any effect in the other item. Copying schema items can be accomplished from IJC by right-clicking on the relevant node in the Projects window (in the case of a database view) or in the Lists and queries window (in the case of a list or a query) and select Copy from the contextual menu. After that you can paste it in the same datatree by right-clicking on the datatree node and using the Paste option in its pop-up menu. You can learn more about about copying database view in IJC from the Instant JChem User Guide.
    Please note that you can create your own copy from a schema item only if the item's owner has enabled copying for at leat one user role which you possess.

Need more help? Check out our tutorial video which guides you through the steps of designing a new form in Instant JChem, sharing it with a group of users and, finally, publishing it on the web by using Plexus Connect.