utlplsql permissions

[ekumpe]

I have a user who is new to utplsql and is unable to execute utPLSQL framework as his user while the rest of the team is able to user the utPLSQL framework. The rest of the team was setup in 2020. Three years later we're adding a new user.

We know utPLSQL is installed and working for the team. However, new user receives the following error message.

utPLSQL framework is not installed on your database or not accessable to the user you are connected with

Additionally, the following is executed by the new user. NOTE the "Invalid identifier" error message.

SQL> select substr(ut.version(),1,60) as ut_version from dual;

UT_VERSION

v3.1.10.3349

SQL>
SQL> select
2 xmlserialize( content xmltype(ut_run_info()) as clob indent size = 2 )
3 from dual;
select
xmlserialize( content xmltype(ut_run_info()) as clob indent size = 2 )
from dual

ORA-00904: "UT_RUN_INFO": invalid identifier

I'm assuming there is a grant or grants missing. Is there someone who recognizes the issue or can point me to additional troubleshooting?

[lwasylow]

Hi
I believe the installation was not followed successfully. All the framework object are given public grants. Any new users should access the main objects to run tests.

Can you try reinstall following instructions?

Cheers Lukasz

[lwasylow]

Hi @ekumpe can you confirm if you resolved issue?