CiviCRM Community Forums (archive)

I am new to CiviCRM and experiencing the errors during the Drupal-CiviCRM installation process.

I created a separate database for civiCRM from Drupal database, and created a user with the same name and password as Drupal's database for CiviCRM. The installer screen showed me that "You're ready to install!" "Database version and connection settings have been verified and look correct!", but when I proceed the installation process, I am presented a fatal error message:
".....If you receive a fatal error, refresh this page to continue the installation
Building database schema and setup files...
Cannot execute DROP TABLE IF EXISTS civicrm_pledge_payment: DB Error: insufficient permissions"

Can anybody please tell me what permissions/privileges should be granted to the civiCRM DB user? I did not experience any problem when I was installing civiCRM on my local computer since I simply grant civiCRM user all permissions, but this time is on the testing server, and I don't have control over the DB server. Only my DBA has, but I have to let him know what I exactly need, otherwise, he would be mad at me

So anybody please give me some clear directions on the civiCRM DB user's permission. Much appreciate!!!

Thanks a lot for your quick reply, Hershel!

Is that OK, I mean security wise, if I ask my DBA to grant the civicrm DB user all privileges? He does not like to be bugged too often

Hi Hershel and everybody,

My DBA told me he has already grant all privileges to the civicrm DB, but I am still not able to install the CiviCRM. The error message is:

Cannot execute DROP TABLE IF EXISTS civicrm_pledge_payment: DB Error: insufficient permissions

Do you know why's that?

That's very interesting.
He said the civicrm db user "had everything". Is there a way for me to check this user's privileges? I have the user name and password and had mysql workbench on my computer?

Tried and no these permissions granted

Another question: the DBA said that with all data and structure privileges granted, the database would be easily hacked/messed up by miscellaneous sql injection code. I wonder if there is a list of required permissions for the civicrm database user to ensure the security while having a smooth installation, configuration, and development.

Thanks a lot for your quick response!

The civiCRM has been installed now. The problem was the DBA assigned accidentally the permissions to drupal database user, not the civicrm DB user:(

Many thanks to Hershel for the responses!