the owner of this schema.

Task $2$

In this task, you first create a new database connection for user 'userl' in DBeaver, and then wri

SQL statements for the following sub$-$tasks in schema 'ABC$\_$schema':

Create a table 'car'.

Enter data into the table 'car'.

Create a view named 'view $1\text{'}$ containing the first three columns of table 'car'.

Grant the permission to access the schema 'ABC$\_$schema' to two user 'user$2".$

Grant the permission to access the schema 'ABC$\_$schema' to two user 'user$3\text{'}.$

Grant SELECT permission on table 'car' to user 'user$2\text{'}.$

Grant SELECT permission on view 'view$1\text{'}$ to user 'user$3\text{'}.$

CAR

Task $3$

In this task, you first create a new database connection for user 'user$2\text{'}$ in DBeaver, and then write

a SQL statement to show all data of table 'car' $($in schema 'ABC$\_$schema'$).$

Task $4$

In this task, you first create a new database connection for user 'user$3\text{'}$ in DBeaver, and then write

a SQL statement show all data of view 'viewl' $($in schema 'ABC$\_$ schema'$).$