Skip to content

Create connection pool connect as sysdba without password #511

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
namndt opened this issue Dec 31, 2020 · 2 comments
Closed

Create connection pool connect as sysdba without password #511

namndt opened this issue Dec 31, 2020 · 2 comments
Labels

Comments

@namndt
Copy link

namndt commented Dec 31, 2020

Hi every one,
Can anyone help me how to create connection pool with sysdba without password?
I take a 2 day to read cx_Oracle connection pool document, but no get answer.
I try with cx_Oracle standalone connecto OK
connection = cx_Oracle.connect('/', mode=cx_Oracle.SYSDBA, encoding='UTF-8')
but i don't know do that with cx_Oracle.SessionPool.

@anthony-tuininga
Copy link
Member

There is no way to do this and it is not recommended either! SYSDBA should only be used for specific, targeted reasons. As such, it is best to create a standalone connection, do what you need to do and then close the connection. If you believe you have a legitimate reason for creating such a pool, please let us know!

@namndt
Copy link
Author

namndt commented Jan 2, 2021

There is no way to do this and it is not recommended either! SYSDBA should only be used for specific, targeted reasons. As such, it is best to create a standalone connection, do what you need to do and then close the connection. If you believe you have a legitimate reason for creating such a pool, please let us know!

Happy new year!!
You correct me, thank for your information. I will use standalone connection instead of pool connection.

@namndt namndt closed this as completed Jan 2, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants