Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-12184

Configure DB user permissions on Rice Developer Environment Setup

    Details

    • Type: Task Task
    • Status: Open Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Security Level: Public (Public: Anyone can view)
    • Labels:
    • Similar issues:
      KULRICE-12183Configure KRAD sample app on Developer Environment Setup
      KULRICE-27Document "How To Set Up Your Development Environment" for contributing
      KULRICE-13674Include rice environment number in AppDynamics configurations
      KULRICE-13511krad sampleapp environments not rebuilding db on startup
      KULRICE-13439Rice: KSPD Setup of Clustered Environments for Performance Testing
      KULRICE-4949Fix the mysql ci environment for rice 1.1
      KULRICE-69Prepare a "What to Expect from the Rice KNS Extraction" document to circulate to the developers.
      KULRICE-12287Add a banner to Rice screens to show which environment you are in
      KULRICE-7123Rice 2.1 VCT: Ensure Env4 & Env5 are configured for 2.1 Version Compatibility Testing
      KULRICE-13022Create Environment(s) for Rice 2.5 performance testing
    • Rice Module:
      Rice Core
    • Application Requirement:
      Rice
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required
    • Include in Release Notes?:
      Yes

      Description

      While setting up the Rice Developer environment, running the maven command to configure the DB and load sample app data only creates the DB user 'RICE' and does not set up the user's permissions to the databases 'ricedev' and 'ricetest'.

        Activity

        Hide
        Nisha Gupta (Inactive) added a comment -

        In MySQL, I fixed this by granting the user RICE@localhost all schema privileges to the databases 'ricedev' and 'ricetest'.

        GRANT ALL ON ricedev.* TO 'RICE'@'localhost';
        GRANT ALL ON ricetest.* TO 'RICE'@'localhost';

        Or you can use the MySQL Workbench.

        Show
        Nisha Gupta (Inactive) added a comment - In MySQL, I fixed this by granting the user RICE@localhost all schema privileges to the databases 'ricedev' and 'ricetest'. GRANT ALL ON ricedev.* TO 'RICE'@'localhost'; GRANT ALL ON ricetest.* TO 'RICE'@'localhost'; Or you can use the MySQL Workbench.

          People

          • Assignee:
            Unassigned
            Reporter:
            Nisha Gupta (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Structure Helper Panel