Brocade Communications Systems IP250 user manual Roleprivilegeinfo, Portprofileinfo

Views I

SWITCH_PORT.PORT_NUMBER,

SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.FICON_SUPPORTED, SWITCH_PORT.STATE, SWITCH_PORT.USER_PORT_NUMBER, VIRTUAL_SWITCH.NAME as VIRTUAL_SWITCH_NAME, VIRTUAL_SWITCH.ID as SWITCH_ID, FABRIC.NAME as FABRIC_NAME, FABRIC.MANAGED as FABRIC_MANAGED, PORT_GROUP.ID as PORT_GROUP_ID, PORT_GROUP_MEMBER.ID as PORT_GROUP_MEMBER_ID

from

SWITCH_PORT, VIRTUAL_SWITCH, FABRIC, FABRIC_MEMBER, PORT_GROUP_MEMBER, PORT_GROUP

where

VIRTUAL_SWITCH .ID = SWITCH_PORT.VIRTUAL_SWITCH_ID and

FABRIC_MEMBER.VIRTUAL_SWITCH_ID = SWITCH_PORT.VIRTUAL_SWITCH_ID and FABRIC_MEMBER.FABRIC_ID = FABRIC.ID and

SWITCH_PORT.ID = PORT_GROUP_MEMBER.SWITCH_PORT_ID and PORT_GROUP_MEMBER.PORT_GROUP_ID = PORT_GROUP.ID;

ROLE_PRIVILEGE_INFO

create or replace view ROLE_PRIVILEGE_INFO as select

ROLE.ID,

ROLE.NAME as ROLE_NAME, ROLE.DESCRIPTION as ROLE_DESCRIPTION, ROLE.HIDDEN as ROLE_HIDDEN, PRIVILEGE.ID as PRIVILEGE_ID, PRIVILEGE.NAME as PRIVILEGE_NAME, PRIVILEGE.AREA as PRIVILEGE_AREA,

ROLE_PRIVILEGE_MAP.PERMISSION

from

ROLE,

ROLE_PRIVILEGE_MAP, PRIVILEGE

where

ROLE.ID = ROLE_PRIVILEGE_MAP.ROLE_ID and

PRIVILEGE.ID = ROLE_PRIVILEGE_MAP.PRIVILEGE_ID;

PORT_PROFILE_INFO

create or replace view PORT_PROFILE_INFO as select

PORT_PROFILE.ID,

PORT_PROFILE.SWITCH_ME_ID,

PORT_PROFILE.NAME,

PORT_PROFILE.STATE,

PORT_PROFILE.SWITCH_PORT_MODE, PORT_PROFILE.ACL_PROFILE, PORT_PROFILE.QOS_PROFILE, PORT_PROFILE.FCOE_PROFILE, PORT_PROFILE.VLAN_PROFILE, PORT_PROFILE.VLAN_DETAILS, PORT_PROFILE.DEFAULT_PROFILE, PORT_PROFILE.ACL_NAME, PORT_PROFILE.FCOE_MAP_NAME,

Brocade Network Advisor IP User Manual	1643
53-1003056-01