> [REVIEW] Here we will introduce the oracle user rights assignment and oracel way to export data from the server, hoping to be helpful for the oracle user rights assignment, many people feel is not very difficult, but to do the oracle user privileges distribution need to be carefully and patiently. This paper will be assigned to the user about mid would be the stat of all users authorized to mid table users, that is, mid stat users can access under the table; sqlplus stat / stat to the user login select ' grant select, insert, update, delete on stat. '| | table_name | |' to mid; 'from user_tables; then select all of the statements listed, enter the sysdba privilege to operate: sqlplus "/ as sysdba" and then perform the above All statements, oracle user rights assigned to it; stat users to access stored procedures under the stored procedure under the mid users: enter the sysdba privileges to operate: grant execute any procedure to midgrant execute any procedure to statstat users to access stored procedures under the mid User temporary table types under the user assigns stat will execute any type to stat the second oracle on the server data to a local machine on the method, which is exported without the establishment of a server-side table space and temporary table space on the local machine do not create the table space, just use the default table space in cmd mode, execute the following command exp username / password @ server-side database id file = c: \ filename. dmp such as the following: exp djyy / djyy @ zhwx file = c: \ djyy20090921.dmpexp wxzd / wxzd @ zhwx file = c: \ wxzd20090921.dmp into the local machine's users. to create a user in plsqldeveloper in to the new user name, select tools menuimports tables option to select the oracleimporttag, in whichimportexecutable, select the oracle installation directory db_1 \ bin directory under imp.exe executable file (the default in general do not need to manually change, if not then you can choose the file to the import imp.exe) in the import file, select the export dmp file name suffix, and then perform import to import the following statement to create tablespaces: create tablespace zhwxsysdatafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ zhwxsys.dbf' size 500muniform size 128k; establishment of a temporary table space statement is as follows: create tporary tablespace zhwxtmptpfile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ zhwxtmp.dbf' size 50m>