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
EXECUTE
INDEX
INSERT
LOCK TABLES
SELECT
SHOW VIEW
TRIGGER
UPDATE
Setting User Permissions
SQLyog 12
Look for the User Manager icon:
Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)
SQLyog 8.7
Look for the User Manager icon:
Then select the user and choose to set either global privileges or object level privileges (the example above does global and the one below does object)
MySQL Workbench 6.2
Look for Users and Privileges in the management tab/section
Then select the user and choose to set either global privileges or object level privileges (to limit the user to specific databases)
MySQL Workbench 5.2
Select the connection in the Administration list and then click Manage Security below that
Then select the user and choose to set either global privileges or schema level privileges (to limit the user to specific databases)
Global settings:
Schema settings:
In this section: