summaryrefslogtreecommitdiff
path: root/api-ref/source/users.inc
diff options
context:
space:
mode:
authorLingxian Kong <anlin.kong@gmail.com>2019-12-24 16:53:18 +1300
committerLingxian Kong <anlin.kong@gmail.com>2019-12-24 22:15:09 +1300
commitdacb400e0bc3c267d55c5d99032b4692f421f141 (patch)
tree7045db8cd050ba6c62fcc91821d1f0df8da41f80 /api-ref/source/users.inc
parentb4bc1d85f0f6e3a625cbfb0af1ecb9b08dff310d (diff)
downloadtrove-dacb400e0bc3c267d55c5d99032b4692f421f141.tar.gz
Improve API doc
Change-Id: If48ef016c6fb7a875ceabc9f106e4cd85858d147
Diffstat (limited to 'api-ref/source/users.inc')
-rw-r--r--api-ref/source/users.inc289
1 files changed, 289 insertions, 0 deletions
diff --git a/api-ref/source/users.inc b/api-ref/source/users.inc
new file mode 100644
index 00000000..686a84fd
--- /dev/null
+++ b/api-ref/source/users.inc
@@ -0,0 +1,289 @@
+.. -*- rst -*-
+
+=====
+Users
+=====
+
+
+
+Create user
+~~~~~~~~~~~
+
+.. rest_method:: POST /v1.0/{project_id}/instances/{instanceId}/users
+
+Creates users for a database instance.
+
+When specifying user name and password, you can also specify databases that the user can access.
+
+Normal response codes: 202
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+Request Example
+---------------
+
+.. literalinclude:: samples/user-create-request.json
+ :language: javascript
+
+
+
+
+List database instance users
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+.. rest_method:: GET /v1.0/{project_id}/instances/{instanceId}/users
+
+Lists the users in a database instance and the associated databases for that
+user.
+
+This operation does not return system users. A system user is a
+database administrator who administers the health of the database.
+Also, this operation returns the ``root`` user only if it is
+enabled.
+
+Normal response codes: 200
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+
+Response Example
+----------------
+
+.. literalinclude:: samples/user-list-response.json
+ :language: javascript
+
+
+
+
+Show database instance user
+~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+.. rest_method:: GET /v1.0/{project_id}/instances/{instanceId}/users/{user_name}
+
+Get a specific user information in an instance.
+
+Normal response codes: 200
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+ - user_name: user_name
+
+
+Response Example
+----------------
+
+.. literalinclude:: samples/user-show-response.json
+ :language: javascript
+
+
+
+
+Delete user
+~~~~~~~~~~~
+
+.. rest_method:: DELETE /v1.0/{project_id}/instances/{instanceId}/users/{user_name}
+
+Deletes a user for a database instance.
+
+Normal response codes: 202
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+ - user_name: user_name
+
+
+
+
+Update a user
+~~~~~~~~~~~~~
+
+.. rest_method:: PUT /v1.0/{project_id}/instances/{instanceId}/users/{user_name}
+
+Modify attributes(e.g. user name, allowed host, password) for a specific user.
+
+Normal response codes: 202
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+ - user_name: user_name
+
+Request Example
+---------------
+
+.. literalinclude:: samples/user-put-request.json
+ :language: javascript
+
+
+
+
+Update users passwords
+~~~~~~~~~~~~~~~~~~~~~~
+
+.. rest_method:: PUT /v1.0/{project_id}/instances/{instanceId}/users
+
+Modify passwords for users.
+
+Normal response codes: 202
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+Request Example
+---------------
+
+.. literalinclude:: samples/users-put-request.json
+ :language: javascript
+
+
+
+
+Show root-enabled status for database instance
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+.. rest_method:: GET /v1.0/{project_id}/instances/{instanceId}/root
+
+Shows root-enabled status for a database instance.
+
+Returns ``true`` if root user is enabled for a database instance.
+Otherwise, returns ``false``.
+
+Normal response codes: 200
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+
+Response Example
+----------------
+
+.. literalinclude:: samples/user-check-root-response.json
+ :language: javascript
+
+
+
+
+Enable root user
+~~~~~~~~~~~~~~~~
+
+.. rest_method:: POST /v1.0/{project_id}/instances/{instanceId}/root
+
+Enables the root user for a database instance and returns the root password.
+
+This operation generates a root password for the root user and
+enables the root user to log in from any host.
+
+Enabling root user should only be restricted to admin user, as with root user,
+the cloud user can change the database settings, e.g. remove users which
+bypassing the Trove API.
+
+Normal response codes: 200
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+
+Response Example
+----------------
+
+.. literalinclude:: samples/user-enable-root-response.json
+ :language: javascript
+
+
+
+
+Disable root user
+~~~~~~~~~~~~~~~~~
+
+.. rest_method:: DELETE /v1.0/{project_id}/instances/{instanceId}/root
+
+Disables the root user.
+
+Normal response codes: 204
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+
+
+
+Show root-enabled history for database instance
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+.. rest_method:: GET /v1.0/{project_id}/mgmt/instances/{instanceId}/root
+
+Admin only API. Show the date and time that root user was enabled(if ever) for
+an instance.
+
+Normal response codes: 200
+
+
+Request
+-------
+
+.. rest_parameters:: parameters.yaml
+
+ - project_id: project_id
+ - instanceId: instanceId
+
+
+Response Example
+----------------
+
+.. literalinclude:: samples/user-show-root-history-response.json
+ :language: javascript \ No newline at end of file