Skip to content

Instantly share code, notes, and snippets.

View vinijmoura's full-sized avatar

Vinicius Moura vinijmoura

347 followers · 18 following
View GitHub Profile
@vinijmoura
vinijmoura / AreaPermissions.sql
Created May 10, 2021 20:45
CREATE TABLE [dbo].[AreaPermissions](
[TeamProjectName] [varchar](100) NULL,
[AreaPathName] [varchar](150) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[AreaCommandName] [varchar](100) NULL,
[AreaCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndAreaPermissions.ps1
Last active May 12, 2021 23:41
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
Function get-Identifier ($children,[ref]$AllAreaPaths)
@vinijmoura
vinijmoura / OrganizationLevelPermissions.sql
Created May 5, 2021 19:07
CREATE TABLE [dbo].[OrganizationLevelPermissions](
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[OrganizationLevelType] [varchar](50) NULL,
[OrganizationLevelCommandName] [varchar](100) NULL,
[OrganizationLevelCommandInternalName] [varchar](100) NULL,
[OrganizationLevelCommandPermission] [varchar](50) NULL
@vinijmoura
vinijmoura / ListUsersGroupsAndOrganizationLevelPermissions.ps1
Created May 5, 2021 19:04
Param
(
[string]$PAT,
[string]$Organization,
[string]$mailAddress,
[string]$Connstr
)
$SQLQuery = "TRUNCATE TABLE OrganizationLevelPermissions"
@vinijmoura
vinijmoura / ProjectLevelPermissions.sql
Created May 2, 2021 20:20
CREATE TABLE [dbo].[ProjectLevelPermissions](
[TeamProjectName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[ProjectLevelType] [varchar](50) NULL,
[ProjectLevelCommandName] [varchar](100) NULL,
[ProjectLevelCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndProjectLevelPermissions.ps1
Created May 2, 2021 20:17
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
@vinijmoura
vinijmoura / PipelinePermissions.sql
Last active April 29, 2021 17:47
CREATE TABLE [dbo].[PipelinePermissions](
[TeamProjectName] [varchar](100) NULL,
[RepoName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[PipelineCommandName] [varchar](100) NULL,
[PipelineCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndPipelinePermissions.ps1
Created April 29, 2021 17:21
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)
@vinijmoura
vinijmoura / GitRepositoriesPermissions.sql
Last active April 27, 2021 12:27
CREATE TABLE [dbo].[GitRepositoriesPermissions](
[TeamProjectName] [varchar](100) NULL,
[RepoName] [varchar](100) NULL,
[SecurityNameSpace] [varchar](100) NULL,
[UserPrincipalName] [varchar](100) NULL,
[UserDisplayName] [varchar](100) NULL,
[GroupDisplayName] [varchar](200) NULL,
[GroupAccountName] [varchar](200) NULL,
[GitCommandName] [varchar](100) NULL,
[GitCommandInternalName] [varchar](100) NULL,
@vinijmoura
vinijmoura / ListUsersGroupsAndGitPermissions.ps1
Created April 27, 2021 12:14
Param
(
[string]$PAT,
[string]$Organization,
[string]$ProjectName,
[string]$mailAddress,
[string]$Connstr
)