Re: Simple DBA question - Users

Sorry to followup my own post, but I realized the error of my ways about 10 minutes after I posted. I am dealing with schemas, not different databases.

Hope I didn't waste anyone's time.

Carol

Carol L. Stimmel wrote:
>
> Hi,
>
> I'm not a trained Oracle DBA (Was trained in Informix DSA, but
> I'm finding not a lot translates). Anyway, I've inherited a
> server that contains several databases in one instance of 7.2.3.
> There are users defined that are assigned to only one of the
> many databases. I have several related questions, as I try
> to recreate a similar scenario.
>
> I want to create a new database in a new tablespace:
>
> create database mydbname
> datafile '/local/datafile/data_01.dbf'
> size 2M;
>
> To execute this successfully, It appears I need to be
> connected internally. Does the database need to be in
> any specific mode for me to accomplish this?
>
> Then, I want to create a user that can only log into
> this database. Now I'm stuck:
>
> create user myuser identified by password
> default tablespace '/local/datafile/data_01.dbf'
>
> This is clearly not enough! How do I restrict this user
> to "mydbname"?
>
> Also, which system tables can I look at to see which
> users are restricted to what databases?
>
> Thanks in advance!
>
> --
> Carol Stimmel
> cstimme_at_advtech.uswest.com Pager: (303) 234-3059
> U S WEST Advanced Technologies Phone: (303) 541-6085
 

-- 
Carol Stimmel
cstimme_at_advtech.uswest.com          	Pager: (303) 234-3059 
U S WEST Advanced Technologies		Phone: (303) 541-6085