Re: Newbie security question

terry_stjean_at_my-deja.com wrote:
>
> We have 2 tablespaces, dev and prod (development and production). We
> have 2 users set up, devuser and produser. Devuser should have read
> access to tablespace prod as well as all data and object access to
> tablespace dev. Produser should have no access to tablespace dev and
> only data access to tablespace prod.
> What do I need to do to set this up this way.
>

Ensure the users default tablespaces are correct. Create identical schemas under each user. create role in PROD with select on all tables assign the role to user devuser.
should be all you need to do.

You do realise that the two schemas could reside in one tablespace and be visible
only to the owner (or those with specific permissions granted)? Received on Tue Sep 12 2000 - 09:46:23 CDT