NEventStore Tables in custom schema

[kblooie]

From @jskrepnek on February 4, 2015 21:33

Hi,

I'm working with a DB requirement (Oracle) that tables be owned by a user ("schema") that is different from the user that accesses those tables. I'm trying to understand how, if possible, to support this with NEventStore and/or Oracle.

For example:

Given a user APPLICATION
and a schema EVENTSTORE

The commits table would need to be 'owned' by EVENTSTORE; i.e.: EVENTSTORE.COMMITS.

Then the user APPLICATION would be granted the necessary privileges to access EVENTSTORE.COMMITS.

However, the APPLICATION user accesses the Commits table implicitly; i.e.: SELECT * FROM COMMITS. As far as I know, the Commits table would be assumed to be owned by the APPLICATION user.

What I need is to be able to have NEventStore explicitly use the owning schema: i.e.: SELECT * FROM EVENTSTORE.COMMITS

I appreciate that this may as much be a problem that we solve outside of NEventStore; so I'm hoping to connect with others that have worked around a similar situation.

Thanks,

Joel

Copied from original issue: NEventStore/NEventStore#386

[kblooie]

From @damianh on February 22, 2015 18:0

I don't know is the short answer. I strongly suspect you'd have to modify all of the oracle native statements.

[DamianReeves]

I'd suggest creating synonyms to the EVENTSTORE.COMMITS table.

[hrannzo]

While the library has no built-in support for controlling the schema or table names, it's still possible to extend the ISqlDialect interface with a decorator to apply transformations on the underlying SQL statements.
You can see a simple string replacement solution for MsSqlDialect in this gist