subversion-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stuempfig, Thomas" <thomas.stuemp...@siemens.com>
Subject RE: Check Path based authorization
Date Thu, 13 Dec 2018 08:30:17 GMT
Hi Pavel,

thank you very much for your help. Your solution works.
This makes real value for of VisualSVN here.

Regards
Thomas

From: Pavel Lyalyakin [mailto:pavel.lyalyakin@visualsvn.com]
Sent: Mittwoch, 12. Dezember 2018 20:38
To: Stuempfig, Thomas (DF PL S&SE DE PSM EAI) <thomas.stuempfig@siemens.com>
Subject: Check Path based authorization

Hello Thomas,

On Wednesday, December 12, 2018, Stuempfig, Thomas <thomas.stuempfig@siemens.com<mailto:thomas.stuempfig@siemens.com>>
wrote:
> Hi Pavel,
> i am impressed by the speed of your answer.

We value any feedback on our products, Subversion and version control in general. Therefore,
we regularly monitor social media, forums and mailing lists. Feel free to share any other
feedback or requests and we will examine them too.

> here is the content of the VisualSVN-WinAuthz.ini as a mini example user_a, and user_b
are members of Group_A. user_a and user_b can access the repo... but I do not have a chance
to verify it upfront with a tool... as admin svnauthz is "rw" for Group_A and user_a but "no"
for user_b....
>
> [/]
> S-1-5-21-954228201-601818101-482762101-101590=rw  (Group_A)
> S-1-5-21-954228201-601818101-482762101-5978=rw (user_a)
>
> the real one is much larger. The repos vary from 1-10years of history from 5000 files
and folders to 8 Million files and Folders
> We have ~15000 potential read users and 500 committers. (We are a small part of Siemens)
> Consider different path / group / user-group memberships...
>
>
> And I need a solution to this one

Please, see the attached PowerShell script that essentially loads a new cmdlet in addition
to those available in current VisualSVN Server versions. The cmdlet returns effective access
of a user account for a given repository path. We think that this is exactly what you are
looking for. :)

DISCLAIMER: The script is provided without any warranty or support. You can use and adjust
it on your own risk.

Please, follow these steps to run the script:

  *   Download and rename the attachment to Get-SvnEffectiveAccess.ps1 (i.e. remove the trailing
underscore character).
  *   Start the PowerShell console that has the VisualSVN Server's PowerShell module loaded
(this has to happen by default) or via the dedicated PowerShell console:

        *   Start the VisualSVN Server Manager console.
        *   Select Action | All Tasks.
        *   Click Start PowerShell.

  *   Load the script to your current PowerShell session with this command (note the dot character
and replace PATH with an actual path to the script's directory):
. PATH\Get-SvnEffectiveAccess.ps1

  *   Run the following command:
Get-SvnEffectiveAccess -Repository MyRepo -Path /branches/MyBranch -AccountName DOMAIN\username
The command should return effective access of the DOMAIN\username account for the /branches/MyBranch
path in the MyRepo repository.

> I envisage a workaround based on the following powershell com
> Get-ADPrincipalGroupMembership -Identity USERXXXX | Format-Table -Property SID -AutoSize
> Cycle throug the results and run svnauthz with each resulting line. This should in principle
give me some hint about the privilege
> But I don't know if VisualSVN grants widest privilege or first privilege.

VisualSVN Server conforms to main principles of the path-based authorization mechanism used
in Subversion. Please, see the article KB33: Understanding VisualSVN Server authorization<https://www.visualsvn.com/support/topic/00033/>.

We will wait for your reply.

> -----Original Message-----
> From: Pavel Lyalyakin [mailto:pavel.lyalyakin@visualsvn.com<mailto:pavel.lyalyakin@visualsvn.com>]
> Sent: Mittwoch, 12. Dezember 2018 11:39
> To: Stuempfig, Thomas (DF PL S&SE DE PSM EAI) <thomas.stuempfig@siemens.com<mailto:thomas.stuempfig@siemens.com>>
> Cc: brane@apache.org<mailto:brane@apache.org>; users@subversion.apache.org<mailto:users@subversion.apache.org>
> Subject: Re: Check Path based authorization
>
> Hello Thomas,
>
> On Tue, Dec 11, 2018 at 8:40 PM Stuempfig, Thomas <thomas.stuempfig@siemens.com<mailto:thomas.stuempfig@siemens.com>>
wrote:
>>
>> Hi Brane,
>> well after testing the tool does not actually do what i would like. But it is giving
me a starting point / work around.
>> I tested the tool with Visualsvn Server on windows
>
> VisualSVN Server includes a PowerShell module[1] that provides a set of cmdlets[2] for
server and repository administration. You may want to try the `Get-SvnAccessRule`[3] and `Select-SvnAccessRule`[4]
cmdlets - I guess that they can partially meet your requirements.
> However, they do not consider AD user's group membership and therefore do not display
effective access for a particular user account.
>
> Do I understand you correctly that you want a reporting tool that will display actual
effective access for AD user DOMAIN\Username considering his group membership? How complex
is the access rule configuration in your repositories? Could you please show us an example
(run Get-SvnAccessRule and show us the output)? You can reply me privately or contact support@visualsvn.com<mailto:support@visualsvn.com>
and we will examine your case further.
>
> [1]: https://www.visualsvn.com/server/features/powershell/
> [2]: https://www.visualsvn.com/support/topic/00088/
> [3]: https://www.visualsvn.com/support/topic/00088/#Get-SvnAccessRule
> [4]: https://www.visualsvn.com/support/topic/00088/#Select-SvnAccessRule
>
>> Steps to reproduce
>> 1) configure basic windows authentication
>>
>> 2) grant" rw" access to the repository root path for AD group
>>         Visualsvn server places the objectSid
>> S-1-1-11-111111111-111111111-11111111-11111  of the group in the
>> VisualSVN-WinAuthz.ini file of the repository
>>
>> 3) svnauthz.exe accessof --username S-2-2-22-222222222-22222222-222222222-22222 d:\repositories\test\conf\VisualSVN-WinAuthz.ini
>>   Where username is a member of the AD group objectSid
>> S-1-1-11-111111111-111111111-11111111-11111
>>  Result no
>>
>> But
>> 4) svnauthz.exe accessof --username
>> S-1-1-11-111111111-111111111-11111111-11111  22222
>> d:\repositories\test\conf\VisualSVN-WinAuthz.ini
>> Gives "rw"
>>
>>
>> This is not what I am looking for.
>>
>> I could probably use some ldap query in order to find out the groups where user S-2---
is member of and test these against the svn file, I personally don't like ldap queries but
if needed I will stick with that.
>>
>> So I am seeking for better ideas... or if anybody already did the job of cycling
through ones user AD groups recursively... calling svnauthz for each of the groups I would
offer some beer ...
>>
>> regards
>> Thomas
>>
>> -----Original Message-----
>> From: [ext] Stuempfig, Thomas [mailto:thomas.stuempfig@siemens.com<mailto:thomas.stuempfig@siemens.com>]
>> Sent: Dienstag, 11. Dezember 2018 17:22
>> To: Branko Čibej <brane@apache.org<mailto:brane@apache.org>>; users@subversion.apache.org<mailto:users@subversion.apache.org>
>> Subject: RE: Check Path based authorization
>>
>> Hi Brane,
>> thank you for the quick response. This is probably what I would seek for. I'll test
it and will come back with my findings.
>>
>> Best regards
>> Thomas
>>
>> -----Original Message-----
>> From: Branko Čibej [mailto:brane@apache.org<mailto:brane@apache.org>]
>> Sent: Dienstag, 11. Dezember 2018 11:00
>> To: users@subversion.apache.org<mailto:users@subversion.apache.org>
>> Subject: Re: Check Path based authorization
>>
>> On 11.12.2018 10:24, Stuempfig, Thomas wrote:
>> > Hi all,
>> > We have a large organization many projects and quite a bit of history (10years)
with one of the repos… and after a while path based authorization becomes quite difficult.
>> > I would like to ask if it is possible as an admin to check path based authorization
for a user x (ldap).
>> >
>> > It would be great if one could give (“none”,”rw”,”r”) or alike for
path.
>> > Kind executing a call like the call below as admin.
>> >
>> > getactiveprivs usertocheck
>> > http(s)://server.domain.com//svn/myproject/branches/branch_dev/<http://server.domain.com/svn/myproject/branches/branch_dev/>
>> >
>> > I mean this is the core, there could be several variations of this call. Get
privs of ldap group members … as different members belong to different other groups each
of them have possibly different access rights. It would be really great to have some table
of active priviledges.
>>
>>
>> Is the 'svnauthz' tool not good enough? It's usually installed separately from the
core binaries, in some 'subversion-tools' package, but it's intended for exactly this kind
of test.
>>
>>
>> -- Brane
>>
>> $ svnauthz accessof --help
>> accessof: Print or test the permissions set by an authz file.
>> usage: 1. svnauthz accessof TARGET
>>        2. svnauthz accessof -t TXN REPOS_PATH FILE_PATH
>>
>>   1. Prints the access of USER to PATH based on authorization file at TARGET.
>>      TARGET can be a path to a file or an absolute file:// URL to an authz
>>      file in a repository, but cannot be a repository relative URL (^/).
>>
>>   2. Prints the access of USER to PATH based on authz file at FILE_PATH in the
>>      transaction TXN in the repository at REPOS_PATH.
>>
>>   USER is the argument to the --username option; if that option is not
>>   provided, then access of an anonymous user will be printed or tested.
>>
>>   PATH is the argument to the --path option; if that option is not provided,
>>   the maximal access to any path in the repository will be considered.
>>
>> Outputs one of the following:
>>      rw    write access (which also implies read)
>>       r    read access
>>      no    no access
>>
>> Returns:
>>     0   when syntax is OK and '--is' argument (if any) matches.
>>     1   when syntax is invalid.
>>     2   operational error
>>     3   when '--is' argument doesn't match
>>
>> Valid options:
>>   -t [--transaction] ARG   : transaction id
>>   --username ARG           : username to check access of
>>   --path ARG               : path within repository to check access of
>>   --repository ARG         : repository authz name
>>   --is ARG                 : instead of outputting, test if the access is
>>                              exactly ARG
>>                              ARG can be one of the following values:
>>                                 rw    write access (which also implies read)
>>                                  r    read-only access
>>                                 no    no access
>>   --groups-file ARG        : use the groups from file ARG
>>   -R [--recursive]         : determine recursive access to PATH
>>
>> -----------------
>> Siemens Industry Software GmbH; Anschrift: Franz-Geuer-Str. 10, 50823
>> Köln; Gesellschaft mit beschränkter Haftung; Geschäftsführer: Urban
>> August, Daniel Trebes; Sitz der Gesellschaft: Köln; Registergericht:
>> Amtsgericht Köln, HRB 84564
>> -----------------
>> Siemens Industry Software GmbH; Anschrift: Franz-Geuer-Str. 10, 50823
>> Köln; Gesellschaft mit beschränkter Haftung; Geschäftsführer: Urban
>> August, Daniel Trebes; Sitz der Gesellschaft: Köln; Registergericht:
>> Amtsgericht Köln, HRB 84564
>
>
>
> --
> With best regards,
> Pavel Lyalyakin
> VisualSVN Team
> -----------------
> Siemens Industry Software GmbH; Anschrift: Franz-Geuer-Str. 10, 50823 Köln; Gesellschaft
mit beschränkter Haftung; Geschäftsführer: Urban August, Daniel Trebes; Sitz der Gesellschaft:
Köln; Registergericht: Amtsgericht Köln, HRB 84564
>

-----------------
Siemens Industry Software GmbH; Anschrift: Franz-Geuer-Str. 10, 50823 Köln; Gesellschaft
mit beschränkter Haftung; Geschäftsführer: Urban August, Daniel Trebes; Sitz der Gesellschaft:
Köln; Registergericht: Amtsgericht Köln, HRB 84564
Mime
View raw message