Effective User Management performed by DBA"s.

The user or users with the administrator role are solely responsible for managing users who have been granted database access.

The administrator is in charge of controlling how other users in your organization access your database. The administrator, for example, can add new users, deny access to users who have left the organization, and assist users who are unable to log in.

Administrators are responsible for the following tasks:

• Create new users
• Users should be removed.
• Control user access
• Configure user connection privileges.
• Change user permissions.
• View current user permissions.
• Passwords for users should be changed.

Database user management typically involves the following tasks:

1. Creating user accounts: The first step in user management is to create user accounts for individuals or groups who need access to the database. Each account is typically assigned a unique username and password.

2. Modifying user accounts: Administrators may need to modify user accounts from time to time, for example, to update passwords or change access permissions.

3. Granting and revoking access permissions: Administrators can assign specific privileges to users, such as read-only access or the ability to make changes to the data. They can also revoke these permissions if necessary.

4. Monitoring user activity: It's important to monitor user activity within the database to identify any suspicious behavior or potential security breaches.

5. Deleting user accounts: When an employee leaves an organization or no longer requires access to a particular database, their user account should be deleted to prevent unauthorized access.

A database user is a user account that is allowed to access specified database objects. 

Depending on the DBMS and security policies, a user might be explicitly created 

and authenticated within the database system or may be created externally and authenticated 

using external authentication such as the operating system 

or external identity management services like Kerberos, LDAP, and Cloud IAM.

A database role defines a set of permissions needed to 

undertake a specific role in the database. 

For example, a backup operator role would have permissions to 

access a database and to perform backup functions. 

Some RDBMSs have a set of predefined roles that you can use for your users, 

such as a database owner or backup operator role.

Effective database user management is essential for maintaining the security and reliability of a database. By ensuring that only authorized users have access to sensitive data, organizations can protect themselves against potential data breaches and other security risks.