The owner is the user to whom the account belongs. By default, the owner has full rights and only the owner can access the My account settings. Note, there can only be one owner of an account.
Admin - Can create and delete web applications, can create, edit and delete users and groups. The Admin can open and run any web application.
Standard User - Can create and delete web applications and can open and use them. But a Standard User cannot manage users and groups.
Limited user - Can open and use web applications with restricted access but cannot create, edit or delete web applications. Also the Limited User cannot manage users and groups.
Limited user with no access to Data Tab - Can open and use web applications with restricted access but cannot create, edit or delete web applications and cannot access the Data Tab. Also the Limited user with no access to Data Tab cannot manage users and groups.
Limited user with no access to Applications Tab - Can open and use web applications with restricted access but cannot create, edit or delete web applications and cannot access the Applications Tab. Also the Limited user with no access to Applications Tab cannot manage users and groups.
Guest User - Has no access to Control Panel, can only access one application by the URL. The Guest User will be required to register when they try to reach the application for the first time. Guest User can be managed through the User Tab.
Guest User with Data - Has no access to Control Panel, can only access one application by the URL and can access its own data from the previous login. The Guest User with Data will be required to register when they try to reach the application for the first time. Guest User with Data can be managed through the User Tab.
Suspend an Account
There is now a new feature in the User & Groups tab marked "Suspend Account".
Next to a user name, you will find the
button. If you
click this, the account you have selected will be suspended. This means that
they will be unable to log on, edit, or use any of the applications they would
normally be able to access. By pressing the same button in the future, you can
unlock an account and restore full privileges to the user.
Reset User Account
There is a new feature in the User & Groups tab marked "Reset Account." Next
to each user name, you will find the
button. If you
press this button, the user's account settings will be reset to default. This
cannot be undone, but privileges can be altered through the edit button.
Custom Role Definition
A new tab in SpreadsheetWEB, Custom Roles, enables the user to create new custom roles for the other users in addition to built-in user types. Note that this feature is only available to System Admin and the changes will be applicable to all sites on the server.
Add a New Custom Role
To add a new custom role, click on "Customs Role" tab and then click on the "Add New Custom Role" button under the tab.
'Custom Role Definitions' allows the user to set new user roles with diverse combinations of rights available in SpreasheetWEB. These rights are listed in the screenshot below.
Main categories control access to tabs in the Control Panel. Sub categories will define the new role with different privileges. Please note that you have to click on the check boxes before each main category, if you want them to appear on the user's control panel as main tabs.
Applications
By clicking on "Add Web Application", "Add Web Service" or "Delete Web Application", you will be setting privileges to this new role on managing web applications.
Data
Again, under the data section, you may give the right to this new user role to manage database by editing, copying or deleting records, as well as the rights to see the record history, change their status or import data.
Processes
If you enable the processes tab for the new role, the user will be able to use it.
Users & Groups
You may customize the new role by giving them the right to manage users and groups. Accordingly, the new role will hold any or none of the sub rights.
Specials
By granting this right, the new user role will have the right to integrate web applications with your webpage, blog, etc.
Analytics
The user with this right will be privileged to create traffic reports on each application for a certain date range.
My Account
If this right is given, then the user will be allowed to manage your account.
LDAP
The user will have access to LDAP settings.
Manage Roles
By clicking on Manage Roles (and one or more sub rights), the user (system admin, here) will be granting their sole right to manage roles to a new user (custom role).
Once a new custom role is created (e.g. Role01), any user with the right to add a new user will be able to see the new custom role (Role01) in the "user roles" list, and assign the role to a particular user.
Note that the user may edit the existing custom roles at any time.
On top of the owner, SpreadsheetWEB allows three other user types. How many users you can create depends on your SpreadsheetWEB subscription.
| Edition | Number of allowed users
|
| Free individual edition | 1 |
| Team Edition | 5 |
| Professional Edition | 50 |
| Enterprise Edition | 500 |
Note: the numbers above denote the maximum number of users including the owner. For example, the individual edition allows no additional users, the team edition allows four additional users.
To create additional users click the Users & Groups tab in the navigation menu. Next, click the link Add a user.
A new page will be opened where you need to enter the new user's details.
First, provide a username for the new user. Then enter his or her first and last name, a valid e-mail address, which can be the same as the user name, and a password.
User role - what rights the new user will have by selecting one of the three user types. For more information on user types please follow this link.
Member of group - Finally, you can decide to which group you want to assign the new user. By assigning a user to a group and by assigning a web application to the same group, you can manage who can access restricted web applications and who can not.
To change the user type click the User & Groups tab in the navigation menu. Next, go to the user in the table and click the edit button 
in the same row. A new pages opens with a table that lists the user specific settings. Here go to user role and activate the option button next to the user type you wish to select for your user. For more information about user types, please see User types.
To change the user's last name, first name, and password click the User & Groups tab in the navigation menu. Next, go to the user in the table and click the edit button in the same row. A new pages opens with a table that lists the user specific settings. Here, you can edit the first and last name of the user. In the textfield next to password you can change the user's password.
To assign a user to a group or groups click the User & Groups tab in the navigation menu. Next, go to the user in the table and click the edit button in the same row. A new pages opens with a table that lists the user specific settings. Here go to Member of Group and from the combo box select the group or groups that you wish to assign the user to.
To create a group please go to Users & Groups by clicking the tab Users & Groups in the navigation bar. Then click the link 
manage groups. A new page with the heading Manage groups will appear. Here click 'add a new group'. Again a new page will appear with a small table taking only two rows.
Next to Name of the new group enter the name for the new group. Place new group in in the second row is only important, if you have previously created a group and wish to make the new group a sub-group of the existing group. For example, if you have previously created a group company and now want to create a group finance, which will belong to the finance department of your company, then it makes sense to place the finance group in the company group.
When you assign a web application to a group, all users that are in this particular group have access to it. For example, when you assign a web application to the group finance all users that are are assigned to the group finance can access it. If finance is a sub-group of the group company, all users registered to the group company can access the web applications assigned to finance.
There is a hierarchy of access rights. Users of a group have access to all web applications assigned to sub-groups. But if a web application belongs to a group of the same level or a higher level, a user cannot access their web applications.
To delete a group please go to Users & Groups by clicking the tab Users & Groups in the navigation bar. Then click the link manage groups. A new page with the heading Manage groups will appear. Here activate the check boxes of the groups you wish to delete and then click Delete selected groups above the group list.
To edit the name of a group please go to Users & Groups by clicking the tab Users & Groups in the navigation bar. Then click the link manage groups. A new page with the heading Manage groups will appear. Next, go to the group you wish to rename in the table and click the edit button in the same row. A new window appears showing below table.
To rename the group simply enter a new name in the text field next to Name of the new Group.
To move a group or a sub-group please go to Users & Groups by clicking the tab Users & Groups in the navigation bar. Then click the link manage groups. A new page with the heading Manage groups will appear. Next, go to the group you wish to move and click the edit button in the same row. A new window appears showing below table.
Next to Place new group in is a combo box. By selecting a new containing group you can move the current group. To make the group a top-level group place it in All Groups.
I cannot move the group company under finance. Why is this? For example, if your group set up is as follows:
| Company | |
| - Finance | |
| - Marketing | |
| - Sales | |
Company is the top-level group. The other groups finance, marketing and sales are sub-groups. You can make marketing become a sub-group of finance but you cannot make company a sub-group of finance because it is already inside company and you cannot make a group a sub-group of itself.
Multiple Group Assignment To an Application
Create a new group as seen below:
Then add a web application, and select one or more groups that you want your application to be assigned to.
You can edit your groups under the Users & Groups tab and review which application is shared with which groups under the Applications tab.