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
What am I missing ?
Found out what I was missing:
The DBA had to directly grant the permissions to the unit-test user.
Unit test does not accept permission given to public or through a role.
I find that this is a bug and I will reports it as such