如何在Azure的sql管理门户中更改服务帐户的权限 [英] how to change permission for the service account in azure's sql management portal

问题描述

我想通过Azure的sql管理门户从sql表中删除一个条目.当我查询"DROP USER" XXX时，它说"无法删除用户'XXX'，因为它不存在或您没有权限. 在哪里可以更改服务帐户从表中删除条目的权限?

I want to delete an entry from my sql table, through Azure's sql management portal. When I query "DROP USER "XXX" " it says "Cannot drop the user 'XXX', because it does not exist or you do not have permission." Where can I change permission for the service account to delete entries from table?

推荐答案

我假设这个问题与您之前的问题有关(

I'm assuming this question is related to your previous question (how to delete an entry from azure sql?). DROP USER will try to remove a user which has access to your database, this has nothing to do with removing a record from the Users table. To remove a record from the users table, execute the following query:

DELETE FROM dbo.Users WHERE Username = 'Nazerke'

这篇关于如何在Azure的sql管理门户中更改服务帐户的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！