Hi Everyone
We have a provider with a on-premise Oracle server.
We user sqldeveloper to connect and run scripts
First Example:
Connect:
conn user/password@company
Script
create or replace directory CRYSTAL as 'C:\Crystal\test';
This runs fine.
However I wish to remote connect to sqlplus using sqldeveloper to run a script that need to be run under the sysdba privilege.
So using sql plus on the server it works fine
system/password@company
I then run the script:
grant execute on dbms_crypto to _companyname_LIVE;
I want to run this command from SQL developer so I do not have to connect up remotely using the cloud providers vpn etc.
I can connect using the first example and run script fine.
However when I try and connect to sqldeveloper with the sysdba option it just says the following
hostname / port / servicename work fine when connecting to a standard user but not when using the SYSDBA role.
Can anyone help me?