SUSE Manager/RDBMS

From MicroFocusInternationalWiki
Revision as of 12:32, 9 August 2011 by Bmaryniuk (Talk | contribs) (Created page with "<h1>RDBMS setup</h1> Additional notes for setting up the databases. <h2>Oracle 11g</h2> It is known that Oracle 11g database may end up with invalid objects that previously fail...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

RDBMS setup

Additional notes for setting up the databases.

Oracle 11g

It is known that Oracle 11g database may end up with invalid objects that previously failed to compile. To prevent this happening, Oracle 11g should have the following commands run against the Spacewalk database:

revoke execute on UTL_FILE from public;
revoke execute on UTL_HTTP from public;
revoke execute on UTL_SMTP from public;
revoke execute on UTL_TCP from public;
revoke execute on DBMS_RANDOM from public;
revoke execute on DBMS_EXPORT_EXTENSION from public;
revoke execute on DBMS_JOB from public;
revoke execute on DBMS_LOB from public;