New Error Oracle 19 - SADMIN needs to be granted access to index tablespace
Hi Support,
Just hit a new error while running the database configuration wizard to create a new OOTB Siebel database. I had to issue a grant for the index tablespace. On previous Siebel versions I had only granted the data tablespace.
alter user SADMIN quota unlimited on SIEBEL1X;
In order to get the install to work. My grant user is much older than the current OOTB grant user but it does not issue this grant either.
Before I had issued this command the install failed trying to import the repository because s_app_ver was empty. As it turns out all the inserts for seed data failed with an error message that the user did not have permission on the index tablespace which caused all of the seed data inserts to fail.