如何授予我的 blob 存储触发函数删除表的权限

发布于 2025-01-14 12:45:23 字数 438 浏览 2 评论 0原文

我编写了一个 blob 存储触发函数，但在其中收到一个错误

无法删除表“TABLE_NAME”，因为它不存在或您没有权限。

这是错误源自的代码。

data = pd.read_sql('SELECT * FROM ['+blob_name_file+']', conn)
df2 = pd.concat([data,processed_df])
df2.to_sql(blob_name_file, conn, if_exists = 'replace', index=False)

当需要将新列追加到表中时，将运行此代码。它尝试删除表并创建一个新表，但似乎我的 blob 存储触发器函数无权从数据库中删除表。我已允许 Azure 服务和资源在其防火墙中访问我的数据库，但我还能做什么来确保我的触发器拥有所需的权限？

原文

I've written a blob storage trigger function and in it I'm receiving an error

Cannot drop the table 'TABLE_NAME', because it does not exist or you do not have permission.

Here's the code that the error is originating from.

data = pd.read_sql('SELECT * FROM ['+blob_name_file+']', conn)
df2 = pd.concat([data,processed_df])
df2.to_sql(blob_name_file, conn, if_exists = 'replace', index=False)

This code runs when there's a new column that needs to be appended to the table. It tries to drop the table and create a new one, although, it seems my blob storage trigger function doesn't have permission to drop tables from the database. I've allowed Azure services and resources to access my database in its firewall, but what else can I do to make sure my trigger has the permissions it needs?

分享到QQ

分享到微博