Re: add tables to a user scheme

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 29 Mar 2006 12:05:08 -0500
Message-ID: <FaCdnWn4HsnbI7fZRVn-uQ@comcast.com>

<antonberg1_at_gmx.de> wrote in message
news:1143650180.764682.23380_at_g10g2000cwb.googlegroups.com...
: Hi,
:
: I am using TOAD to organize my Oracle Test database. I created a new
: user and know want to assign to this user some tables and views like
: dba_segments, etc. How can I do this?
:
: Thanks for your help,
: Anton
:

users are not assigned tables, they either own them or have privileges granted on them

you may want to look at the Oracle Concepts manual to get familiar with Oracle database object security and system privileges

you can also look at the GRANT command in the SQL reference manual

in case you are not aware, oracle manuals are freely available at http://tahiti.oracle.com

++ mcs Received on Wed Mar 29 2006 - 11:05:08 CST