Re: how is multi user concurrent READ enabled with oracle

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 21 Mar 2006 07:23:39 -0800
Message-ID: <1142954619.564823.248890@u72g2000cwu.googlegroups.com>

Jack wrote:
> Thanks Mark,
>
> Those items are enabled to allow READ during OLTP processing, which is
> great. I am not talking about that - rather simply talking about multi
> user READ access, independent of transactions, read consistency, data
> consistency - those are all issues that come up when mixing writing
> with reading .. I am only speaking of straight multi user READ as in a
> data mart. What features are enabled for this (buffer pools ?)..

Well you can create a login ( username ) in an oracle database.

CREATE USER ABC123 IDENTIFIED BY PASSWORD ... Then privileges on database objects ( tables ) can be granted to ROLEs.

The login can be granted access to those ROLES.

Multiple logins can access the same database objects if permissions are granted.

Is this what you are talking about? Received on Tue Mar 21 2006 - 09:23:39 CST