Creating a database user
This request packet creates user MyUser on the database with ID 55.
<packet version="1.4.2.0">
<database>
<add-db-user>
<db-id>55</db-id>
<login>MyUser</login>
<password>hello</password>
</add-db-user>
</database>
</packet>
A positive response from the server can look as follows:
<packet version="1.4.2.0">
<database>
<add-db-user>
<result>
<status>ok</status>
<id>132</id>
</result>
</add-db-user>
</database>
</packet>
If the database was not found, the response looks as follows:
<packet version="1.4.2.0">
<database>
<add-db-user>
<result>
<status>error</status>
<errcode>1015</errcode>
<errtext>Database not found</errtext>
</result>
</add-db-user>
</database>
</packet>
If the login name is already used by another user account on this database, the response looks as follows:
<packet version="1.4.2.0">
<database>
<add-db-user>
<result>
<status>error</status>
<errcode>1007</errcode>
<errtext>User already exists</errtext>
</result>
</add-db-user>
</database>
</packet>
Creating multiple database users
This packet creates user MyUser on the databases with ID 55 and ID 57.
<packet version="1.4.2.0">
<database>
<add-db-user>
<db-id>55</db-id>
<login>MyUser</login>
<password>hello</password>
</add-db-user>
<add-db-user>
<db-id>55</db-id>
<login>My2User</login>
<password>123456</password>
</add-db-user>
</database>
</packet>
If the first operation succeeded and the database with ID=57 was not found, the response from the server looks as follows:
<packet version="1.4.2.0">
<database>
<add-db-user>
<result>
<status>ok</status>
<id>132</id>
</result>
</add-db-user>
<add-db-user>
<result>
<status>error</status>
<errcode>1015</errcode>
<errtext>Database not found</errtext>
</result>
</add-db-user>
</database>
</packet>
Previous page
Next page
Locate page