Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: added some more details with images
Section
Column
width70%

Having trouble deleting topics?

    • Story Topic
    • Twitter Topic
    • League

etc

even when they have no content in them...

 

This is a system setup issue that is related to the database user permission in use by Flow.

Database User Permissions Required

The user needs to have these permissions assigned:

ALTER
ALTER ROUTINE
CREATE
CREATE ROUTINE
CREATE TEMPORARY TABLES
CREATE VIEW
DELETE
DROP
EVENT
EXECUTE
GRANT
INDEX
INSERT
LOCK TABLES
REFERENCES
SELECT
SHOW VIEW
TRIGGER
UPDATE 

Setting User Permissions

SQLyog 12

Look for the User Manager icon:

Image Added

Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)

Image Added

MySQL Workbench 6.2

Look for Users and Privileges in the management tab/section

Image Added

Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)

Image Added


Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1

In this section:

Table of Contents
indent15px

Include Page
DAS:Promos Top
DAS:Promos Top

...