failed to create port with security group of other tenant

[zhanghao]

How to reproduce this problem:
1.source demo-openrc
2.openstack security group create sg001
3.source admin-openrc
4.openstack port create port001 --network net10 --security-group sg001 Failed
  prompt the following error:
  Security group sg001_id does not exist
5.openstack port create port002 --network net10
  openstack port set port002 --security-group sg001 OK
  port002 security group ids include sg001_id

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/745089

[Miguel Lavalle (minsel)]

It seems we lost the capability of doing what submitter proposes in this change: https://review.opendev.org/#/c/635311/22/neutron/db/securitygroups_db.py

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/745089
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=cc54a1c38e0b537883de43fecda781034c80daf3
Submitter: Zuul
Branch: master

commit cc54a1c38e0b537883de43fecda781034c80daf3
Author: zhanghao <email address hidden>
Date: Thu Aug 6 04:02:36 2020 -0400

    Fix port can not be created with the sg of other project

    This patch adds the verification of whether admin context when
    verifying the valid security groups of port.

    Change-Id: I2674bdc448d9a091b9fe8c68f0866fd19141c6be
    Closes-Bug: #1890539

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/ussuri
Review: https://review.opendev.org/746322

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/746322
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=083748fadd8d739a99d1dacb747d2fec79b7cc27
Submitter: Zuul
Branch: stable/ussuri

commit 083748fadd8d739a99d1dacb747d2fec79b7cc27
Author: zhanghao <email address hidden>
Date: Thu Aug 6 04:02:36 2020 -0400

    Fix port can not be created with the sg of other project

    This patch adds the verification of whether admin context when
    verifying the valid security groups of port.

    Change-Id: I2674bdc448d9a091b9fe8c68f0866fd19141c6be
    Closes-Bug: #1890539
    (cherry picked from commit cc54a1c38e0b537883de43fecda781034c80daf3)

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/train
Review: https://review.opendev.org/747065

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/stein
Review: https://review.opendev.org/747066

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/747066
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=494f9751d3b8d85c91494a290a64c175126b6b57
Submitter: Zuul
Branch: stable/stein

commit 494f9751d3b8d85c91494a290a64c175126b6b57
Author: zhanghao <email address hidden>
Date: Thu Aug 6 04:02:36 2020 -0400

    Fix port can not be created with the sg of other project

    This patch adds the verification of whether admin context when
    verifying the valid security groups of port.

    Conflicts:
        neutron/tests/unit/extensions/test_securitygroup.py

    Change-Id: I2674bdc448d9a091b9fe8c68f0866fd19141c6be
    Closes-Bug: #1890539
    (cherry picked from commit cc54a1c38e0b537883de43fecda781034c80daf3)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/747065
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=40a6b4b9e6f4fb06decc885f0419e79bbff731ec
Submitter: Zuul
Branch: stable/train

commit 40a6b4b9e6f4fb06decc885f0419e79bbff731ec
Author: zhanghao <email address hidden>
Date: Thu Aug 6 04:02:36 2020 -0400

    Fix port can not be created with the sg of other project

    This patch adds the verification of whether admin context when
    verifying the valid security groups of port.

    Conflicts:
        neutron/tests/unit/extensions/test_securitygroup.py

    Change-Id: I2674bdc448d9a091b9fe8c68f0866fd19141c6be
    Closes-Bug: #1890539
    (cherry picked from commit cc54a1c38e0b537883de43fecda781034c80daf3)