topic Can an Oracle database Role own version? in Data Management Questions

Can an Oracle database Role own version?

AndrewCollins2 — Fri, 31 Aug 2012 06:25:31 GMT

Can an Oracle database Role own a version? As opposed to an Oracle User owning a version. It would be great if every user belonging to a role was about to post and reconcile a version owned by that role (rather than each user owning their own version)

Re: Can an Oracle database Role own version?

VinceAngelo — Fri, 31 Aug 2012 10:38:12 GMT

Users own tables and versions. Keep in mind that a "version" is just a label on a state --
there's only a row in a table to keep track, and only one user, while that user can belong
to many roles, and no mechanism for keeping track of the role you want so associate
with the state.

- V

Re: Can an Oracle database Role own version?

AndrewCollins2 — Mon, 03 Sep 2012 00:55:23 GMT

Does that mean in an organisation where staff change roles (eg. data QA role) often, that operating system authentication is unworkable?

Re: Can an Oracle database Role own version?

VinceAngelo — Mon, 03 Sep 2012 11:46:58 GMT

Can you explain how you come to the "unworkable" conclusion? I don't see any
conflicts between version ownership and OS authentication.

- V