I am trying to implement Transperent Data Encryption. I am done with setting up the wallet and creating the tablespace.
My doubt is how to specify tablespace so that every object(tables/functions/triggers/etc) is created inside that tablespace.
Can it be done by altering user as below so that every object created by
user1 is automatically created inside the tablespace
securespace? Assuming the following command does so.
ALTER USER "user1" DEFAULT TABLESPACE "securespace" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
or do I have to specify
securespace in every DDL statement?