Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

How to Generate a Security Report for EPM Workspace

|| || 1

How to Generate a Security Report for EPM Workspace
Stechies

I found this query but it ends with Error

SELECT AL1.NAME, AL5.css_identity, AL3.NAME, AL5.css_identity_type, AL4.NAME
FROM biplus.V8_CONTAINER AL1 LEFT OUTER JOIN biplus.V8_ACCESS_CTRL AL2 ON (AL1.CONTAINER_UUID=AL2.RESOURCE_ID) LEFT OUTER JOIN biplus.V8_IDENTITY AL3 ON (AL2.GRANT_ID=AL3.ID) LEFT OUTER JOIN (SELECT D4AL1.SUBJECT_ID, D4AL1.CSS_IDENTITY, 'User'
FROM biplus.V8_CSS_USER D4AL1 UNION SELECT AL3.GROUP_ID, AL3.CSS_IDENTITY, 'Group'
FROM biplus.V8_CSS_GROUP AL3 UNION SELECT AL2.ROLE_ID, AL2.CSS_IDENTITY, 'Role'
FROM biplus.V8_CSS_ROLE AL2) AL5 (subject_id, css_identity, css_identity_type) ON (AL2.ACCESSOR_ID=AL5.subject_id) LEFT OUTER JOIN biplus.V8_METATYPE AL4 ON (AL1.META_TYPE_UUID=AL4.META_TYPE_UUID)

Error at Command Line:5 Column:44
Error report:
SQL Error: ORA-00905: missing keyword
00905. 00000 - "missing keyword"

Thanks


Know more about SAP BI


Comments

  • Sonia Barwar
    18 Mar 2014 12:48 pm Best Answer

    SELECT AL1.NAME, AL5.css_identity, AL3.NAME, AL5.css_identity_type, AL4.NAME
    FROM biplus.V8_CONTAINER AL1 LEFT OUTER JOIN biplus.V8_ACCESS_CTRL AL2
    ON
    (AL1.CONTAINER_UUID=AL2.RESOURCE_ID)
    LEFT OUTER JOIN
    biplus.V8_IDENTITY AL3
    ON
    (AL2.GRANT_ID=AL3.ID)
    LEFT OUTER JOIN
    (SELECT D4AL1.SUBJECT_ID, D4AL1.CSS_IDENTITY 'User',
    FROM biplus.V8_CSS_USER D4AL1
    UNION
    SELECT AL3.GROUP_ID, AL3.CSS_IDENTITY 'Group',
    FROM biplus.V8_CSS_GROUP AL3 UNION SELECT AL2.ROLE_ID, AL2.CSS_IDENTITY
    'Role',
    FROM biplus.V8_CSS_ROLE AL2) AL5
    (subject_id, css_identity, css_identity_type)
    ON
    (AL2.ACCESSOR_ID=AL5.subject_id)
    LEFT OUTER JOIN
    biplus.V8_METATYPE AL4
    ON
    (AL1.META_TYPE_UUID=AL4.META_TYPE_UUID)

                ---------------Original Message---------------
    From: chagooooo
    Sent: Monday, March 17, 2014 4:29 PM
    Subject: How to Generate a Security Report for EPM Workspace

    I found this query but it ends with Error

    SELECT AL1.NAME, AL5.css_identity, AL3.NAME, AL5.css_identity_type, AL4.NAME
    FROM biplus.V8_CONTAINER AL1 LEFT OUTER JOIN biplus.V8_ACCESS_CTRL AL2 ON (AL1.CONTAINER_UUID=AL2.RESOURCE_ID) LEFT OUTER JOIN biplus.V8_IDENTITY AL3 ON (AL2.GRANT_ID=AL3.ID) LEFT OUTER JOIN (SELECT D4AL1.SUBJECT_ID, D4AL1.CSS_IDENTITY, 'User'
    FROM biplus.V8_CSS_USER D4AL1 UNION SELECT AL3.GROUP_ID, AL3.CSS_IDENTITY, 'Group'
    FROM biplus.V8_CSS_GROUP AL3 UNION SELECT AL2.ROLE_ID, AL2.CSS_IDENTITY, 'Role'
    FROM biplus.V8_CSS_ROLE AL2) AL5 (subject_id, css_identity, css_identity_type) ON (AL2.ACCESSOR_ID=AL5.subject_id) LEFT OUTER JOIN biplus.V8_METATYPE AL4 ON (AL1.META_TYPE_UUID=AL4.META_TYPE_UUID)

    Error at Command Line:5 Column:44
    Error report:
    SQL Error: ORA-00905: missing keyword
    00905. 00000 - "missing keyword"


Advertisement
Advertisement
Advertisement