Managing users

The Users table

The Users table is a centralized repository where all user accounts within the Cinchy platform are managed. This table typically includes critical information about each user, such as usernames, encrypted passwords, email addresses, and roles. It allows effective management of user access and permissions across the Cinchy platform.

Administrators can use this table to add, modify, or deactivate user accounts, reset passwords, and manage other user-specific settings.

User table reference

Column	Description	Example
Cinchy Id	Unique identifier for a user in Cinchy.	-7
Username	User's login name.	john.doe@cinchy.com
Authentication Method	Method used for user authentication.	Cinchy User Account
Password	Encrypted password of the user.	[Encrypted password]
Email Address	Email address of the user.	johndoe@cinchy.com
Email Verification Code	Code sent to user for email verification.	[Verification code]
Email Verified	Indicates if the user's email is verified (True/False).	False
First Name	User's first name.	John
Last Name	User's last name.	Doe
Name	Full name of the user.	John Doe
Display Name	Name displayed in the user interface.	John Doe (johndoe)
Profile Photo	Binary data for user's profile photo.	[Profile photo data]
Password Expiration Timestamp	Timestamp when the user's password expires.	[Expiration timestamp]
Is Disabled	Indicates if the user account is disabled (True/False).	False
Locked Timestamp	Timestamp when the user account was locked.	[Locked timestamp]
Can Design Tables	Indicates if the user can design tables (True/False).	False
Can Design Queries	Indicates if the user can design queries (True/False).	False

Create a new Cinchy user with a specified password

To create a new user in Cinchy, do the following:

Initial Setup

1. Open the Users Table: Access the Users table in the Cinchy platform.
2. Set the Password:
   • Find the encrypted value for your user password.
   • Create a new user entry.
   • Copy and paste the encrypted value into the Password field for the new user.
3. Configure Password Expiration:
   • Assign the current date as the Password Expiration Timestamp for the new user.

Update the password

4. Use Incognito Mode:
   • Launch an Incognito window in your web browser.
   • Navigate to the Cinchy website.
5. Initial Login:
   • Log in with the new user credentials using your password.
6. Change the Password:
   • Follow the prompt to change the password upon login.
   • Set a new default password. This will be the standard password for the new account.

Final steps

7. Update User Information:
   • Return to the original Users table session.
   • Refresh the table.
   • Eliminate the Password Expiration Timestamp for the new user.

Change a user password

Overview

This process details how to reset a user password using a known encrypted password value. The example below uses cinchy as the clear text password, which corresponds to the encryption key below.

Reset user password

1. Identify the User: Locate the user account in the Cinchy Users table whose password needs resetting.

2. Use the Encrypted Password:

   • Copy the following encrypted password value, which represents the clear text password 'cinchy': 1000:sKAplLcO6oNvd5XdwnSnERpcgEWIo/5u:q0E9AFowGCstIL/ZNWc4tcAo513BdYw+
   • Paste this encrypted value into the Password field of the user's account.

3. Set Password Expiration:

   • Adjust the Password Expiration Timestamp to today's date for the user.
   • This ensures that the user is prompted to change their password upon their next login.

caution

When resetting a password, you must know the clear text password corresponding to the encrypted value. This is required for the reset process and to communicate the temporary password to the user.