Why databases require accounts
This database solution was designed to offer a better and more efficient way to manage data for users. It aims to make things easier by including simple accounts that contain all the necessary elements for healthy and effective database communication.
The real reason why a database needs accounts is because they serve as the main and secure access point for all database actions, including storing, viewing, editing, and managing data in an organized and controlled way.
The two types of accounts
Many databases have complex role structures and multiple access points, which can be confusing and hard to manage efficiently. In our case, this is no longer a problem because we came up with a brilliant and practical idea: only two simple account types.
- Main account ( Responsible for managing the entire database )
- Member account ( Has specific access to assigned parts of the database )
While there can be multiple accounts within a single database unit, only one main account is allowed per database unit. However, each database unit can have multiple member accounts.
How the main account operates
The main account is the most important account in the database, as it has full control over all core functions. This includes creating and managing components, adding and organizing items, assigning member accounts, and overseeing other critical settings. Essentially, the main account acts as the central administrator, ensuring that the database runs smoothly and securely.
The main account operates as an integral part of the database, and without it, the database cannot function properly. It is one of the most important elements besides the database itself. The main account is also the primary way to communicate with database, making it essential for managing and maintaining the system effectively.
- Has full access to the database unit
- Translates complex database functions into manageable actions
- Makes work easier for the user
- Acts as the main access point for members in the back
How the member account operates
A member account is a sub-account of the main account and is connected to the database through it. Its main role is to allow other users to work with the database unit they have been granted access to, enabling easier work without full control over the entire system.
Members cannot see other members within the same database, ensuring individual privacy. They also have no access to members from other databases or instances. Likewise, each main account has access only to its own database unit and is unaware of the existence of other database units or main accounts.
- Has access to limited resources
- Access permissions are set by the main account
- Is a trusted member of the database
- Belongs to only one database unit
Members in the database should represent real people who are part of the database, different from the main account which represents the organization, company, or group.
When assigning an email to a member account, make sure to use the user's real email address instead of someone else's main email. Otherwise, it may cause problems later.
Private information
Both accounts have private information, with the password being the most important. All member data, except password, is visible to the main account but not to other members, ensuring a secure way of working. Only the main account knows how many members are present in the database unit.
Never reveal your password or other sensitive information to anyone, as it could lead to real data loss and other serious problems.
Passwords are highly secure, keeping accounts well protected. The main account's email is only visible to the main account itself, while member emails are visible to the main account but not to other members. Members cannot see or know about other members in the database unit.