Tuesday, November 18, 2008

List Workbooks and their owners

-- Scripts
-- The following script lists all workbooks, their owners and who the workbook is shared with, if -- at all.

SELECT
DOC.DOC_NAME DOC_NAME ,
OWN_USR.EU_ID OWNER_ID,
OWN_USR.EU_USERNAME OWNER_NAME,
SH_USR.EU_ID GRANTEE_ID,
SH_USR.EU_USERNAME ACCESS_USER
FROM
EUL5_US.EUL5_EUL_USERS SH_USR,
EUL5_US.EUL5_ACCESS_PRIVS PRV,
EUL5_US.EUL5_DOCUMENTS DOC,
EUL5_US.EUL5_EUL_USERS OWN_USR
WHERE
PRV.AP_TYPE(+) = 'GD'
AND PRV.AP_EU_ID = SH_USR.EU_ID(+)
AND PRV.GD_DOC_ID(+) = DOC.DOC_ID
AND OWN_USR.EU_ID = DOC.DOC_EU_ID
ORDER BY DOC_NAME

1 comment:

  1. Gracias, estos queries me han caido como del cielo, asi que mil google de gracias

    ReplyDelete