ODP.NET doesn't support Oracle Connection as SYSASM The 2019 Stack Overflow Developer Survey Results Are InWhen to use static classes in C#Case insensitive 'Contains(string)'Interface defining a constructor signature?How to write a .Net application that works with both SqlServer and Oracle (now that System.Data.OracleClient is deprecated)Problem on using ODP.NetODP.NET Connection Pooling ParametersODP.NET: The provider is not compatible with the version of Oracle clientDoes ODAC 11.2.0.1.2 (ODP.NET 2.112.1.2) support .NET Entity Framework?Why not inherit from List<T>?ODP.NET - disable auto commit
is usb on wall sockets live all the time with out switches off
Why is it "Tumoren" and not "Tumore"?
Did USCIS resume its biometric service for UK visa?
Why do UK politicians seemingly ignore opinion polls on Brexit?
How to create dashed lines/arrows in Illustrator
How was Skylab's orbit inclination chosen?
Can't find the latex code for the ⍎ (down tack jot) symbol
The difference between dialogue marks
How to answer pointed "are you quitting" questioning when I don't want them to suspect
If the Wish spell is used to duplicate the effect of Simulacrum, are existing duplicates destroyed?
What is a mixture ratio of propellant?
Springs with some finite mass
Unbreakable Formation vs. Cry of the Carnarium
Where to refill my bottle in India?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Evaluating number of iteration with a certain map with While
Carnot-Caratheodory metric
What do hard-Brexiteers want with respect to the Irish border?
What does "rabbited" mean/imply in this sentence?
Is this food a bread or a loaf?
I see my dog run
Dual Citizen. Exited the US on Italian passport recently
Falsification in Math vs Science
"What time...?" or "At what time...?" - what is more grammatically correct?
ODP.NET doesn't support Oracle Connection as SYSASM
The 2019 Stack Overflow Developer Survey Results Are InWhen to use static classes in C#Case insensitive 'Contains(string)'Interface defining a constructor signature?How to write a .Net application that works with both SqlServer and Oracle (now that System.Data.OracleClient is deprecated)Problem on using ODP.NetODP.NET Connection Pooling ParametersODP.NET: The provider is not compatible with the version of Oracle clientDoes ODAC 11.2.0.1.2 (ODP.NET 2.112.1.2) support .NET Entity Framework?Why not inherit from List<T>?ODP.NET - disable auto commit
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I realized that odp.net doesn't support for DBA Privileges as 'SYSASM'. It only supports for 'SYSDBA,SYSOPER'.
I want to make sure that is that correct? jdbc connections can connect as sysasm but in .net it seems its not possible.
How can i solve this problem? What should be workaround for that?
c# connection-string odp.net
asked Mar 8 at 8:28
S. DoeS. Doe
205
add a comment |
I realized that odp.net doesn't support for DBA Privileges as 'SYSASM'. It only supports for 'SYSDBA,SYSOPER'.
I want to make sure that is that correct? jdbc connections can connect as sysasm but in .net it seems its not possible.
How can i solve this problem? What should be workaround for that?
c# connection-string odp.net
asked Mar 8 at 8:28
S. DoeS. Doe
205
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39
add a comment |
I realized that odp.net doesn't support for DBA Privileges as 'SYSASM'. It only supports for 'SYSDBA,SYSOPER'.
I want to make sure that is that correct? jdbc connections can connect as sysasm but in .net it seems its not possible.
How can i solve this problem? What should be workaround for that?
c# connection-string odp.net
asked Mar 8 at 8:28
S. DoeS. Doe
205
I realized that odp.net doesn't support for DBA Privileges as 'SYSASM'. It only supports for 'SYSDBA,SYSOPER'.
I want to make sure that is that correct? jdbc connections can connect as sysasm but in .net it seems its not possible.
How can i solve this problem? What should be workaround for that?
c# connection-string odp.net
c# connection-string odp.net
asked Mar 8 at 8:28
S. DoeS. Doe
205
asked Mar 8 at 8:28
S. DoeS. Doe
205
asked Mar 8 at 8:28
S. DoeS. Doe
205
asked Mar 8 at 8:28
S. DoeS. Doe
205
asked Mar 8 at 8:28
S. DoeS. Doe
205
205
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39
add a comment |
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55059317%2fodp-net-doesnt-support-oracle-connection-as-sysasm%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55059317%2fodp-net-doesnt-support-oracle-connection-as-sysasm%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
According to the doc: docs.oracle.com/cd/E11882_01/win.112/e23174/…, it seems correct : "Oracle allows database administrators to connect to Oracle Database with either SYSDBA or SYSOPER privileges. This is done through the DBA Privilege attribute of the ConnectionString property."
– vc 74
Mar 8 at 8:39