createPool() could support privilege: oracledb.SYSDBA

[andylwelch]

1. Describe your new request in detail

Currently it is not possible to create a connection pool with privilege. Given individual connections accept this, it would be a nice to have option to streamline many requests in a pool.

2. Give supporting information about tools and operating systems. Give relevant product version numbers

Thanks for your work, the v6 thin client is great!

[sharadraju]

Thanks for using node-oracledb Thin mode.

We will explore this!

[sharadraju]

@andylwelch This is now fixed in 6.5.1. Please Please verify and thank you for contributing!

[andylwelch]

Thanks @sharadraju . Yes I can confirm this is working now. I am no longer getting the error: Error: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

I didn't realise it was meant to be supported as the automatically included types docs I was clicking through to said;

• OracleDB.PoolAttributes doesn't include the privilege option and,
• ConnectionAttributes.privilege explicitly stated: * Note only non-pooled connections can be privileged.

I now realise these types are maintained independently.

Thanks again for your work!