Issue Plesk Api get db user why permission denied?

[pasamsin]

I am connecting the API with the hosting username and password. If I want to list the users belonging to a database belonging to the same hosting, I get an error. If the database user does not have any database privileges, the users are listed. What is the problem? How can we correct this plesk error?

<packet>
<database>
<get-db-users>
<filter>
<db-id>11</db-id>
</filter>
</get-db-users>
</database>
</packet>


SimpleXMLElement Object ( [@attributes] => Array ( [version] => 1.6.8.0 ) [database] => SimpleXMLElement Object ( [get-db-users] => SimpleXMLElement Object ( [result] => Array ( [0] => SimpleXMLElement Object ( [status] => error [errcode] => 1006 [errtext] => Permission denied. [filter-id] => 11 [id] => 11 ) [1] => SimpleXMLElement Object ( [status] => error [errcode] => 1006 [errtext] => Permission denied. [filter-id] => 11 [id] => 13 ) ) ) ) )

 

[IgorG]

with the hosting username and password

Do you mean that it is not Plesk admin user and password?

 

[pasamsin]

Not with admin

In the image below, you can see 3 users.
No one has access to just one.
Access unauthorized user windo_anyaccess
In the second picture you can see the difference of the database user.

SimpleXMLElement Object
(
[@attributes] => Array
(
[version] => 1.6.8.0
)

[database] => SimpleXMLElement Object
(
[get-db-users] => SimpleXMLElement Object
(
[result] => Array
(
[0] => SimpleXMLElement Object
(
[status] => ok
[filter-id] => 20
[id] => 24
[login] => windo_kullanici
[db-id] => 20
[acl] => SimpleXMLElement Object
(
[host] => %
)

[allow-access-from] => SimpleXMLElement Object
(
)

)

[1] => SimpleXMLElement Object
(
[status] => ok
[filter-id] => 20
[id] => 25
[login] => windo_kullanici2
[db-id] => 20
[acl] => SimpleXMLElement Object
(
[host] => %
)

[allow-access-from] => SimpleXMLElement Object
(
)

)

[2] => SimpleXMLElement Object
(
[status] => error
[errcode] => 1006
[errtext] => Permission denied.
[filter-id] => 20
[id] => 27
)

)

)

)

)