Hello

Is it possible to pass in the authorization when creating a schema with the 
oracle dialect?

oracle_engine = create_engine(
f"oracle://{user}:{password}@{host}:{port}/{database_name}"
)
inspector = inspect(oracle_engine)
if schema_name not in inspector.get_schema_names():
oracle_engine.execute(CreateSchema(schema_name))

I tried to pass in the authorization as a kw variable but no luck:

if schema not in inspector.get_schema_names():
connectable.execute(CreateSchema(schema), authorization=user)

Regards
Soumaya

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/ff2f5a13-c17c-43ea-a469-041a306a2e62n%40googlegroups.com.

Reply via email to