gitlab_applicationgitlab_branchgitlab_commitgitlab_epicgitlab_groupgitlab_group_access_requestgitlab_group_hookgitlab_group_iterationgitlab_group_membergitlab_group_projectgitlab_group_push_rulegitlab_group_subgroupgitlab_group_variablegitlab_hookgitlab_instance_variablegitlab_issuegitlab_merge_requestgitlab_merge_request_changegitlab_my_eventgitlab_my_issuegitlab_my_projectgitlab_projectgitlab_project_access_requestgitlab_project_container_registrygitlab_project_deploymentgitlab_project_iterationgitlab_project_jobgitlab_project_membergitlab_project_pages_domaingitlab_project_pipelinegitlab_project_pipeline_detailgitlab_project_protected_branchgitlab_project_repositorygitlab_project_repository_filegitlab_project_variablegitlab_settinggitlab_snippetgitlab_usergitlab_user_eventgitlab_version
Table: gitlab_project_access_request
The gitlab_project_access_request
table can be used to query information about access requests for a specific project.
However, you must specify a project_id
in the where or join clause.
Examples
List all access requests for a specific project
select id, username, name, state, access_level, created_at, requested_atfrom gitlab_project_access_requestwhere project_id = 45453535;
Get a specific access request by id
select username, requested_atfrom gitlab_project_access_requestwhere project_id = 45453535 and id = 873;
Query examples
Schema for gitlab_project_access_request
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
access_level | bigint | The numeric value of the access level requested by the user. | |
access_level_description | text | The access level requested by the user. | |
created_at | timestamp with time zone | Timestamp of access request creation. | |
id | bigint | The ID of the access request. | |
name | text | The name of the user requesting access. | |
project_id | bigint | = | The ID of the project - link to `gitlab_project.id |
requested_at | timestamp with time zone | Timestamp of access request submission. | |
state | text | The state of the access request. | |
username | text | The username of the user requesting access. |