I'm running the code below against an oracle database:
from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base, DeferredReflection
Base = declarative_base(cls=DeferredReflection)
class User(Base):
__tablename__ = 'user'
__table_args__ = {'schema':'si'}
#Create a session to use the tables
engine = create_engine('oracle://teste:[email protected]:1512/prod')
Base.prepare(engine)
lst_col= [c.name for c in User.__table__.columns]
print (lst_col, len(lst_col))
But I'm getting a warning with the follow message:
python3.6/site-packages/sqlalchemy/dialects/oracle/base.py:1653: SAWarning:
Got 'None' querying 'table_name' from all_cons_columns - does the user have
proper rights to the table?
The query runs, but with the warning.
In the tests I made I see that if I give "select any table" privilege to
the user it runs without any warning, but for security reasons I don't
wan't to give that kind of privilege that gives the user possibility to
query any table in the all database. I gave all permissions on that table
to the "teste" user, and by sql it's possible to query and do any
operations in the table, also it's possible to do all operation by python
but with the warning.
Can you please help me find what I doing wrong, or what is the problem?
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
