René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"NEventStore Tables in custom schema","articleBody":"_From @jskrepnek on February 4, 2015 21:33_\n\nHi,\n\nI'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.\n\nFor example:\n\nGiven a user APPLICATION\nand a schema EVENTSTORE\n\nThe commits table would need to be 'owned' by EVENTSTORE; i.e.: EVENTSTORE.COMMITS.  \n\nThen the user APPLICATION would be granted the necessary privileges to access EVENTSTORE.COMMITS.  \n\nHowever, 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.\n\nWhat I need is to be able to have NEventStore explicitly use the owning schema: i.e.: SELECT \\* FROM EVENTSTORE.COMMITS\n\nI 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.\n\nThanks,\n\nJoel\n\n_Copied from original issue: NEventStore/NEventStore#386_\n","author":{"url":"https://github.com/kblooie","@type":"Person","name":"kblooie"},"datePublished":"2015-05-23T20:14:47.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/5/NEventStore.Persistence.SQL/issues/5"}