In your first week, you were handed the task of implementing the following:

TASKS:

1. Create user Ahmed after verifying password with a function.

2. Create a table Users in Ahmeds schema with UserName (PK), Password, and Type. Store Password column data in encrypted (Transparent Data Encryption with SALT) form. Enter sample data given below in USERS table.

3. Update Type column data by encrypting it using DBMS_CRYPTO package.

UserName Password Type

Ali Ali Student

Khalid Ali Manager

Shoib Sam Manager

Hamdan Hammy Student