Rolf Scherer wrote:
Can I access the sysdd Tables directly (e.g SYSDD.NEW_PRIVILEGES)? When yes,
how, with witch account?
Can I create DOMAIN.VIEWS without reload the system tables?
Sample:
CREATE VIEW DOMAIN.VIEW SEQPRIVILEGES AS
SELECT * FROM SYSDD.NEW_PRIVILEGES WHERE TYPE = 'SEQUENCE'
I get the error: [-4004] (at 15): Unknown table name:NEW_PRIVILEGES
You can have a look at the files in <depend path>/env to see how the
system tables are created. We do not recommend relying on the SYSDD
tables as their structure is purely an implementation detail (meaning
that it can change at whim).
Will the reload of the system tables have any side effects for User Objects?
No.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
