Question $1$

creates an Oracle database user named visitor, with the password manager$234.$

This user is assigned the default tablespace tbs$\_$new$\_10$ with a quota of $50$Mb$.$

This user is also allowed to use the temporary tablespace tbs$\_$temp$\_10.$

This user is forced to change of the password on the user$$s side.

Other limitations are defined by the external profile user$\_$profile$1$ applied to this user.

Question $2$

I want to change the Quota limitation on the default tablespace tbs$\_$ temp $\_10$ with a

quota of $20$Mb for this user and to allow him to be authenticated by the operating

system.

SQL I WANT CODE AND TABLE