• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Issue Plesk Api get db user why permission denied?

pasamsin

New Pleskian
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 ) ) ) ) )
 
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
)

)

)

)

)
 

Attachments

  • 20.JPG
    20.JPG
    44.7 KB · Views: 7
  • 21.JPG
    21.JPG
    60.5 KB · Views: 6
Back
Top