By kursat on

hi,
I want to learn which database permissions to choose to make the whole system more safer for the specific user that has privileges to use database?

The whole permissions are:

select table data
insert table data
update table data
delete table data
create tables
drop tables
grant privileges
reference operations
manage indexes
alter tables
create temp tables
lock tables
create view
show view
create routine
alter routine
execute

⋅ Categories: Drupal 4.5.x or older, Drupal 4.6.x, Drupal 4.7.x, Drupal 5.x, Drupal 6.x

Comments

jscoble’s picture

jscoble commented

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON database.*
TO 'user'@'localhost'
IDENTIFIED BY 'password';

only change localhost if you mysql database isn't on your localhost.

kursat’s picture

kursat commented

should i need drop for core drupal usage?

bennett_pr’s picture

bennett_pr commented

Yes, because if you uninstall a contrib module with tables, Drupal will need to drop the tables associated with the module (if or when you uninstall the module).