Re: creating a user with permit to create

Inki wrote:

> Hello,
>
> (1)
> creating a new user so that I can import a .dmp file that creates tables.
> Did create a user from 'oracle enterprise manager' with admin privileges,
> but i am denied to import with C:> imp .
> how come ? So I did the import using user system, works fine.
>
> (2)
> Am I able to use toad to see how my tables are linked with relation to one
> and other ?
> Possible to see the design of the db that I am importing ?
> I do lack the book 'programming oracle, triggers and stored procedures' by
> kevin owens
> where the design is described.
>
> regards, i

CREATE USER ...
IDENTIFIED BY ...
DEFAULT TABLESPACE ...
TEMPORARY TABLESPACE ...
QUOTA 0 ON SYSTEM
QUOTA ... ON ...; GRANT CREATE SESSION TO ...;
GRANT DBA TO ...; Run your import;

REVOKE DBA FROM ...;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)