I am trying to set Oracle database (instead of HSQL) as the default database to store data regarding my reports. I am using a login ID which has permissions to create table. But I am getting an error "In creating database it has not enough privilege, please modify the privilege for this user". PFA screen shot of the same.
Does the user login ID require permissions to create database? Does this mean the information will be stored within a new schema in the Oracle database?
Please let me know what other privileges the user ID needs to have to accomplish the above successfully.
select t.username,t.granted_role from user_role_privs t
select t.username,t.privilege from user_sys_privs t