| Re: Oracle import 7.1.3 to Oracle 8.1.7 [message #70339] |
Wed, 29 May 2002 07:26 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You do not want to grant DBA to the user. This gives access to all tablespaces. You will not need to precreate objects. All objects will be imported to the users default tablespace. Do this:
drop user cahsuser cascade;
create user cashuser identified by cashuser
default tablespace USERTABLESPACE
temporary tablespace TEMPTABLESPACE;
alter user cashuser quota unlimited on USERTABLESPACE;
alter user cashuser quota 0M on system;
grant connect to cashuser;
REM The following grants are not given with CONNECT role.
grant create procedure to cashuser;
grant create trigger to cashuser;
grant create type to cashuser;
Now run the import:
imp system/manager file=d:dmps2705.dmp FROMUSER=CASHUSER TOUSER=CASHUSER
If cashuser requires DBA privs you can grant it now. Note: you do not need to grant any other privs if the user has DBA. All the privs you listed above are included in the DBA role.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
