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

<antonberg1@gmx.de> wrote in message
news:1143650180.764682.23380@g10g2000cwb.googlegro ups.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