1 -- drop user EBOOKRIGHTS cascade; 2 3 -- Create the user EBOOKRIGHTS 4 create user EBOOKRIGHTS 5 identified by "12345" 6 default tablespace USERS 7 temporary tablespace TEMP 8 profile DEFAULT ; 9 -- Grant/Revoke role privileges 10 grant aq_administrator_role to EBOOKRIGHTS with admin option ; 11 grant connect to EBOOKRIGHTS with admin option ; 12 grant dba to EBOOKRIGHTS with admin option ; 13 grant resource to EBOOKRIGHTS with admin option ; 14 -- Grant/Revoke system privileges 15 grant delete any table to EBOOKRIGHTS; 16 grant insert any table to EBOOKRIGHTS; 17 grant select any table to EBOOKRIGHTS; 18 grant unlimited tablespace to EBOOKRIGHTS with admin option ; 19 grant update any table to EBOOKRIGHTS;
1 exp system / eport@ebook file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp full = y log = D: \ dcis \ DB \ bak \ log \ ebook20100119 . log 2 3 exp system / eport@ebook file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp owner =( EBookRights , JITSERVICE ) log = D: \ dcis \ DB \ bak \ log \ ebook20100119 . log 4 5 imp system / eport@ebook34 file = D: \ dcis \ DB \ bak \ ebook20100119 . dmp fromuser =( PUB_REF , PUB_PARA , EBOOKRIGHTS , OFFLINE_EMS3 , OFFLINE_DEC , JITSERVICE ) log = D: \ dcis \ DB \ bak \ ebook20100119_3 . log buffer = 10240000
转载于:https://www.cnblogs.com/Jason_zhu/archive/2010/09/14/1826057.html
