sql server - Same dbuser used to login with python and sqlclient, but with python it doesnt have same permissions -
as can see in below error using sqlalchemy.
e sqlalchemy.exc.programmingerror: (pyodbc.programmingerror) ('42s02', "[42s02] [microsoft][sql server native client 11.0][sql server]cannot drop table 'the_table', because not exist or not have permission. (3701) (sqlexecdirectw)") [sql: '\n drop table dbo.the_table\n select * dbo.the_table dbo.#the_table_3b49da16_6ae1_4814_a232_4fdec9a5be6b\n grant select on dbo.the_table writers\n drop table dbo.#the_table_3b49da16_6ae1_4814_a232_4fdec9a5be6b\n commit\n ']
the table(the_table) exists.
i new sqlserver , related development , not sure direction move to. accept information might not enough in question, kindly request shall provide.
server: microsoft sql server 2008 r2 (sp3)
Comments
Post a Comment