2 Replies Latest reply on Jan 28, 2016 2:31 PM by KarstenH-dk

    Bug in SQL developer 4.1.3 unit test creating the repository

    KarstenH-dk

      hi

      In order to use the unit test facility, you have create some roles and give some permission to the users and administrators of the unit test repository.

       

      these are

      the roles

      CREATE ROLE UT_REPO_USER ;

      GRANT SELECT ON DBA_TAB_PRIVS TO UT_REPO_USER ;

      GRANT EXECUTE ON DBMS_LOCK TO UT_REPO_USER ;

      CREATE ROLE UT_REPO_ADMINISTRATOR ;

      GRANT UT_REPO_USER TO UT_REPO_ADMINISTRATOR ;

       

      and

      the user/administrators

      GRANT RESOURCE TO MY_USER ;

      GRANT CONNECT TO MY_USER ;

      GRANT CREATE VIEW TO MY_USER ;

      GRANT SELECT ON DBA_ROLES TO MY_USER ;

      GRANT SELECT ON DBA_ROLE_PRIVS TO MY_USER ;

      GRANT UT_REPO_ADMINISTRATOR TO MY_USER ;

       

      But you have to give these permissions directly to the user(s)

      It won't work if you have permissions through a role og through a public permission.

       

      The creation af the unit test repository somehow asks a wrong question when checking a users permission, before creating the repository end therefore

      erroneously rejects a user with the right permissions.

       

      Also it would be a great help if the tool which creates the repository reveals what it is about to do and what it checks beforehand

      i which way it is possible to se what actually might be missing.

       

      regards Karsten