Create a temporary user named Alex to test the configuration.
- Log on as SYSDBA.
-
Create a test user called Alex, who is administered by SYSDBA, with a role of R_Batch_User, using the profile P_Batch_User, with 10 GB perm and 20 GB spool:
CREATE USER Alex FROM SYSDBA AS DEFAULT ROLE=R_Batch_User, PROFILE=P_Batch_User, PERM=10E9, SPOOL=20E9, PASSWORD=password; - Log off.