Hi, 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. Thanks! Mythili
Hi Mythili S,
Thanks for your message,when you change database(Oracle) to store data,you must set up permissions of Oracle's user,the user's permissions must
contain three kinds as follow:
"create any table"
"insert any table"
"unlimited tablespace"
Then you can try again.
Hi Mythili,
Which version of Oracle are you using?
does the CSMARTVOL already exist?
if it does not exist, the studio will try to create it (hence the permissions to create a schema), but if it exists, it should be able to create the tables in it without the need of schema creation permissions.
Hi Sebastiao,
We are using Oracle 11g.
CSMARTVOL already exists.
I am unable to save the settings itself. The error is thrown as soon as I click on "Apply".
Thanks!
Mythili
ok, we have tested today on 10g, but could not reproduce your issue.
Can you give us more details about your permission settings?
Does your schema already contain other tables? or is it empty?
Sebastiao, The schema already contains tables and is in use since a long time. The ID with which I tried is the functional ID and it has all privileges, including creation of tables. I am really curious why the error message says "In creating database it has not enough privilege......" Thanks! Mythili
If you grant your user to have the following 3 privileges, then you should be able to initialize the datamart structure. "create any table" "insert any table" "unlimited tablespace"
