DBadmin privileges to configure already created DW in RRDI setup?
![](http://jazz.net/_images/myphoto/f34e57e05ddaee3985c5a0ae77729e44.jpg)
I'm in the process of configure RRDI on an CLM 4.0.6. In the step 3 "Configure Data Warehouse" , database (DW) administrator user and password is required. It is very difficult to me to get a database administrator user, but I cant access to a user that has access privileges.
If the database is already created , do I required adminitrator privileges ? or can I configure the RRDI step 3 with only a user with read privileges (or what permissions do I need ). ?
Thanks!
One answer
![](http://jazz.net/_images/myphoto/f34e57e05ddaee3985c5a0ae77729e44.jpg)
Hi Cesar,
Assuming the DW database is already created, then you do not need to create a new database. I´d suggest to specify the same credentials that has been specified in CLM (i.e. ccm/admin > Reports > Data Warehouse Connection)
By the way, what´s the database vendor?
Comments
![](http://jazz.net/_images/myphoto/f34e57e05ddaee3985c5a0ae77729e44.jpg)
Hi Alexandre
Yes the DW database is already created. I do not want to create a new database just configure (try to connect) in the RRDI setup. I cant use the same credentials used in CLM , because I did not install/configure the CLM. But I want to ask a user with some privileges/permissions over the DW database. What I dont know what kind of permissions do I need?(If the db is already created). Because getting admin user is kind of impossible here.
I'm using db2
Thanks!
![](http://jazz.net/_images/myphoto/86a47d48218dfecac9f96c1c2d89ec07.jpg)
Hi Cesar,
The user account must have DBADM authority over the DW database.