creating a user with permit to create

[Inki]

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

[Daniel Morgan]

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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Sybrand Bakker]

On Sat, 26 Jun 2004 12:54:26 +0200, "Inki" <inkimar_1968@hotmail.com>
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 oneand other ?Possible to see the design of the db that I am importing ?I do lack the book 'programming oracle, triggers and stored procedures' bykevin owenswhere the design is described.regards, i


1) Grant the user import the imp_full_database privilege
2) The full version of Toad has an E/R diagrammer.
The diagrammer assumes you have PK and FK relationships in your
tables, it doesn't reverse engineer them.


--
Sybrand Bakker, Senior Oracle DBA