DBPrism CMS SQL Scripts
This section includes detailed information about DBPrism CMS SQL scripts.
Directories are relative to the download point of DBPrism CMS.
| Name | SQL Scripts called | Arguments | Run as | Comments |
|---|---|---|---|---|
| create-schemas.sql | drop-context.sql | log_file
cms_repository cms_user_sec cms_user_sec_pwd cms_owner cms_owner_pwd cachehost | SYS | Create database schemas, roles and grants permitions. |
| install-sec.sql | none | log_file
cms_repository cms_user_sec cms_user_sec_pwd cms_owner cms_owner_pwd cachehost | CMS_USER_SEC | Create tables, packages and virtual private database filters. It Also grants permisitions to CMS_OWNER and creates default CMS users and groups. |
| install.sql | cms_tab.sql
cache_spc.sql cache_bdy.sql cms_faq.sql faqtest.sql cms_news.sql cms_rss.sql search.sql | log_file
cms_user_sec cms_owner | CMS_OWNER | SQL script to create DBPrism CMS primary tables, and CMS Extensions such as FAQ report, MoreOver News and SourceForge RSS tables and the Oracle Text search index. |
| CallSpecs.sql | none | log_file
cms_repository cms_user_sec cms_user_sec_pwd cms_owner cms_owner_pwd cachehost | CMS_OWNER | Create Call Spec for Java Stored Procedures, and utility procedures such as UploadNews and UploadRss grants permisitions to CMS_OWNER and creates default CMS users and groups. |
This work is licensed under a
Creative Commons License
.
