1 Reply Latest reply on Jan 28, 2016 12:19 PM by KarstenH-dk

    Unit test SQL dev 4.1.3.20 missing permissions - but which

    KarstenH-dk

      I have asked my dba for the necessary roles and permissions in order to run some unit tests,

      The roles and the permissions for these are - according to the documentation :

       

      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 ;

       

      I have checked that these roles and permissions actually exists

      besides this my user have these permissions ( among a lot of others)

       

      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 ;

       

      When I try to create a repository I get this message

      unit1.jpg

       

       

      What  am I missing ?

       

      regards Karsten