Suggestion to extend the System-View DOMAIN.TABLEPRIVILEGES

Wed, 22 Jan 2003 09:43:46 -0800 

Hello SAP DB Team

I have a suggestion to extend / change the System-View tableprivileges to
the following sample.

This permits queries to determine grants on sequences too.

    createReplaceView (session, 'DOMAIN.TABLEPRIVILEGES',
        """(OWNER,TABLENAME,
           GRANTOR,GRANTEE,PRIVILEGE,IS_GRANTABLE)
        AS SELECT
             OWNER,NAME1,
             GRANTOR,GRANTEE,
             DECODE(SUBSTR(PRIVILEGES,LENGTH(PRIVILEGES),1),'+',
                    SUBSTR(PRIVILEGES,1,LENGTH(PRIVILEGES) - 1),PRIVILEGES),
             DECODE(SUBSTR(PRIVILEGES,LENGTH(PRIVILEGES),1),'+','YES','NO')
           FROM SYSDD.NEW_PRIVILEGES
           WHERE NAME2 IS NULL
           AND TYPE NOT IN('DBPROC', 'ROLE')
        INTERNAL""")

See also
http://listserv.sap.com/pipermail/sapdb.general/2003-January/017053.html

Regards
Rolf



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to