Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i create a mysql user only for application?

User_89RDXSep 21 2022

Our specific requirement is to disable mysql database user from logging in through console i.e. the user should be able to authenticate with the database only through application.
The application user should not be able to login to database using the command mysql -u xxx -p

Comments

Jani Rautiainen-Oracle

I think the main issue you have is the SFTP connection. AFAIK only HTTPS connections are allowed. The documentation states:

Remote invocations with a transport protocol other than HTTPS (including plain text HTTP).

Not applicable.

does the 3rd party provide a web service to obtain the data ?

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi ,

3rd party doesn't have any web-service in place.

I heard ICS supports most of the 3rd party integration. But looks like they are not yet released. Hence trying to find some feasible options through JCS.

Since JCS (SAAS Extension) supports java based applications, can we use some 3rd party libraries in JCS to connect with SFTP through Java application ?

Appreciate your help.

Thanks,

Vasanth

Jani Rautiainen-Oracle

I am not sure; the documentation is fairly clear that only HTTPS is allowed. That said the JCS console does have some SFTP configurations listed so maybe there is some functionality, unfortunately I have no knowledge of this and have to leave it up to guys from JCS to confirm. AFAIK the SFTP details on the console are used for JDeveloper DB Cart functionality to move DM & data between systems..

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi Jani ,

Thanks for your reply.

Instead of JCS SAAS, can i use plain JCS to connect the third party system through SFTP. If so , is there any documentation or examples available on the available approached for using SFTP in JCS ? 

And also need your help to know , if not here, which is the right forum to ask our technical queries on JCS? 

Appreciate your help!

Thanks,

Vasanth

Unfortunately I am also only developer using JCS-SaaS so I cannot give definite answers on "plain JCS" as I do not have an instance to test with so I am limited to the documentation. This is the right forum to ask questions on JCS, I think there was a public holiday in US yesterday so hopefully the JCS guys will give definitive answers soon. I did forward the thread to the JCS product manager.

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Any updates or inputs on the JCS part. Appreciate your help.

Thanks,

Vasanth

1 - 6

Post Details

Added on Sep 21 2022
1 comment
23 views