We have to run Nuxeo with db.user and db.password having no table creation rights and we have successfully configured nuxeo but we have to do the following steps: * Start nuxeo with db.user and db.password having table creation rights. (This step creates all the necessary tables) * Set noDDL as "true" and added custom plugin having directories' table creation policies as "never" * Start nuxeo with db.user and db.password having no table creation rights. Nuxeo starts perfectly fine. We want to avoid step # 1 (first starting nuxeo with db.user and db.password having table creation rights) So we want to create tables via sql db scripts. Is this possible?

I'm not sure to understand your question. Do you ask our permission to do that ? 😄 If you really want, why not 🙂 but you will do exactly the same that what Nuxeo do automatically. Maybe my advices would be * is to allow table creation just for the first start and remove the right after. * or you do the initialization of a pre-production instance identical of your production one and dump the data to inject it into the production instance... But becareful if you do maintenance action (hot fix deployment) or add more feature through studio project or any else action that need the table rights, you may have some instabilities. My real advice will be to let the right. Hope this will help you 😄

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Nuxeo SQL Database Schema Creation

SMAH_Haider

We have to run Nuxeo with db.user and db.password having no table creation rights and we have successfully configured nuxeo but we have to do the following steps:

Start nuxeo with db.user and db.password having table creation rights. (This step creates all the necessary tables)
Set noDDL as "true" and added custom plugin having directories' table creation policies as "never"
Start nuxeo with db.user and db.password having no table creation rights.

Nuxeo starts perfectly fine.

We want to avoid step # 1 (first starting nuxeo with db.user and db.password having table creation rights) So we want to create tables via sql db scripts. Is this possible?

Find more posts tagged with

Accepted answers

Benjamin_Jalon1

I'm not sure to understand your question. Do you ask our permission to do that ? 😄

If you really want, why not 🙂 but you will do exactly the same that what Nuxeo do automatically. Maybe my advices would be

is to allow table creation just for the first start and remove the right after.
or you do the initialization of a pre-production instance identical of your production one and dump the data to inject it into the production instance...

But becareful if you do maintenance action (hot fix deployment) or add more feature through studio project or any else action that need the table rights, you may have some instabilities. My real advice will be to let the right.

Hope this will help you 😄

All comments

Benjamin_Jalon1

I'm not sure to understand your question. Do you ask our permission to do that ? 😄

If you really want, why not 🙂 but you will do exactly the same that what Nuxeo do automatically. Maybe my advices would be

is to allow table creation just for the first start and remove the right after.
or you do the initialization of a pre-production instance identical of your production one and dump the data to inject it into the production instance...

Hope this will help you 😄

SMAH_Haider

Bjalon, Thats the constraint from the client that we cannot run nuxeo with user having table creation rights.

Benjamin_Jalon1

I'm sad for you

Florent_Guillau

The simplest way is to start Nuxeo once on an empty database, then use a database script generation tool to dump its content and turn it into a SQL script.

For instance using PostgreSQL you can use pg_dump --schema-only.