database_roles

Creates, updates, deletes, gets or lists a database_roles resource.

Overview

Name	database_roles
Type	Resource
Id	google.spanner.database_roles

Fields

The following fields are returned by SELECT queries:

projects_instances_databases_database_roles_list

Successful response

Name	Datatype	Description
name	string	Required. The name of the database role. Values are of the form projects//instances//databases//databaseRoles/ where `` is as specified in the CREATE ROLE DDL statement.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
projects_instances_databases_database_roles_list	select	projectsId, instancesId, databasesId	pageSize, pageToken	Lists Cloud Spanner database roles.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databasesId	string
instancesId	string
projectsId	string
pageSize	integer (int32)
pageToken	string

SELECT examples

projects_instances_databases_database_roles_list

Lists Cloud Spanner database roles.

SELECT
name
FROM google.spanner.database_roles
WHERE projectsId = '{{ projectsId }}' -- required
AND instancesId = '{{ instancesId }}' -- required
AND databasesId = '{{ databasesId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}';