You ensure that the set the default value ops

882 Chapter 17 ✦ Study Guide

ALTER USER BOBW
QUOTA UNLIMITED ON DATA01
QUOTA UNLIMITED ON DATA02
QUOTA UNLIMITED ON DATA03
QUOTA 100M ON USERS
QUOTA 100M ON INDX;

ALTER USER MARYB
QUOTA UNLIMITED ON DATA01
QUOTA UNLIMITED ON DATA02
QUOTA UNLIMITED ON DATA03
QUOTA 100M ON USERS
QUOTA 100M ON INDX;

Chapter 17 ✦ Study Guide 883

2. Create a user called MarkS with a password of password. Ensure that MarkS’s

objects will be created on the CERTDB tablespace and that sorts will spill to

SQL> CREATE USER MarkS
2 IDENTIFIED BY password
3 DEFAULT TABLESPACE CERTDB
4 TEMPORARY TABLESPACE TEMP
5 QUOTA 10M ON CERTDB
6 PASSWORD EXPIRE;
CREATE USER MarkS
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20002: Password too simple

SQL>

SQL> ALTER PROFILE DEFAULT LIMIT
2 PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.