1. Zhang Huangbin
  2. iredmail

Commits

Zhang Huangbin  committed de18bdf

PostgreSQL doesn't have CREATE privilege.

  • Participants
  • Parent commits 69e7860
  • Branches default

Comments (0)

Files changed (1)

File iRedMail/functions/roundcubemail.sh

View file
 \i ${PGSQL_SYS_USER_HOME}/rcm.sql;
 
 -- Grant privileges
-GRANT CREATE,SELECT,INSERT,UPDATE,DELETE ON cache,cache_index,cache_messages,cache_thread,contactgroupmembers,contactgroups,contacts,dictionary,identities,searches,session,users TO ${RCM_DB_USER};
-GRANT CREATE,SELECT,UPDATE,USAGE ON contacts_seq,contactgroups_seq,identities_seq,searches_seq,users_seq TO ${RCM_DB_USER};
+GRANT SELECT,INSERT,UPDATE,DELETE ON cache,cache_index,cache_messages,cache_thread,contactgroupmembers,contactgroups,contacts,dictionary,identities,searches,session,users TO ${RCM_DB_USER};
+GRANT SELECT,UPDATE,USAGE ON contacts_seq,contactgroups_seq,identities_seq,searches_seq,users_seq TO ${RCM_DB_USER};
 
 -- Grant privilege to update password through roundcube webmail
 \c ${VMAIL_DB};