He experts,

Customer is not able to change app code so they would like to use 12.0.1. OEM version without authentication on both sides (new db server will be installed without setting database_authentication). Does OEM installation (+OEM license key) has some limitations (programmatic) that requires db to be authenticated or it will work without authentication same as authenticated?

Many thanks!

HP

asked 26 Sep '13, 05:50

Spad's gravatar image

Spad
31113
accept rate: 0%


The limitations of V12 OEM installations are discussed here... in particular, non-authenticated connections have read-only access.

permanent link

answered 26 Sep '13, 07:43

Breck%20Carter's gravatar image

Breck Carter
26.9k437609883
accept rate: 21%

That's true for non-authenticated connections to an authenticated database on an OEM edition.

If my understanding is right, the question is whether a non-authenticated database will run on an OEM edition - and whether it will allow write access? (And I don't have the answer...)


Here's more discussion on OEM edition vs. Authenticated edition - though I don't claim to understand the differences...:

(26 Sep '13, 07:47) Volker Barth
Replies hidden
1

From the Help topic quoted in the reply above: "Authentication is not a security mechanism. Anyone running an unauthenticated database server against the database can perform any operation, subject to the usual SQL permissions scheme."

...that tells me "OEM" and "Authenticated" are attributes of the server software, not the database. The database inherits the attribute when it is started.

TANSTAAFL is the founding principle here, methinks :)

(26 Sep '13, 10:06) Breck Carter

Thanks for asnwers. Question was is it possible to have OEM Edition which doesn't require authentication. And it seems that answer is NO. OEM license key makes installed version OEM Authenticated Edition and it requires server to use authentication, otherwise only read is possible.

(27 Sep '13, 05:23) Spad
Replies hidden
1

I don't think so - in the cited FAQ, Jason has stated:

Yes. A database created for the OEM edition does not have to be authenticated.

(That's the difference between an OEM edition and an Authenticated edition, or at least my understanding of these subtle differences...)

(27 Sep '13, 06:44) Volker Barth

Actually not so subtle... "OEM" is a legal agreement that may or may not imply "Authentication", whereas "Authenticated" is an actual attribute of the software. I'm guessing very few OEM customers get to deploy non-authenticated software, but apparently it is possible.

Volker, thanks for clarifying.

(27 Sep '13, 07:32) Breck Carter

While this forum is a great place to discuss the technical aspects of what will, and won't work, the only place to determine what you are ALLOWED to do is in the text of your license agreement from Sybase. In particular, the un-authenticated version of SQL Anywhere for OEMs usually has a higher royalty fee, if it is allowed by your license.

permanent link

answered 27 Sep '13, 09:34

Chris%20Kleisath's gravatar image

Chris Kleisath
3.2k92836
accept rate: 38%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22
×19

question asked: 26 Sep '13, 05:50

question was seen: 903 times

last updated: 27 Sep '13, 09:34