Shulou(Shulou.com)05/31 Report--

This article shares with you the content of a sample analysis of creating users and database backups for Oracle databases. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Create the user and authorization code:

-- Create the user create user myName-- create user identified by myPwd-- set password default tablespace USERS-- default tablespace USERS temporary tablespace TEMP-- default temporary tablespace TEMP profile DEFAULT;-- Grant/Revoke role privileges grants / revoke role permissions to users grant ctxapp to myName;-- has no meaning, but without this sentence, the statement seems to report an error grant exp_full_database to myName at run time -- assign user exp_full_database permission to perform full-library export with this permission; assign user imp_full_database permission to perform full-library import-- Grant/Revoke system privileges-- grant / revoke system permission grant change notification to myName;grant create any directory to myName;-- to create any folder grant create any table to myName -- create any table grant drop any directory to myName;-- delete any folder grant execute any procedure to myName;-- execute any stored procedure grant unlimited tablespace to myName;-- unlimited tablespace quota-- directly transfer all permissions of certain roles to user grant ctxapp to myName;-- does not make sense, but without this sentence, at run time, the statement seems to report an error grant connect to myName;-- gives the permissions of the connect role to the myName user grant dba to myName -- give permissions for the dba role to the myName user grant resource to myName;-- to the resource role to the myName user

As shown in the code above, there are four small pieces of code in which I created the user

The first step is to create users and default tablespaces and temporary tablespaces (these two nouns have been explained on the Internet, but I am still a little at a loss. I first give the connection of the explanation, and then I hope that the dedicated person can explain it for me.)

The second and third steps are to grant some specific permissions to the user. For more information on the specific functions of each permission, please see the notes.

The fourth step is to transfer the permissions of the three roles to the user, which are described in detail below.

DBA: has all privileges, is the highest privilege of the system, and only DBA can create the database structure.

RESOURCE: users with Resource permissions can only create entities, not database structures (confused about this concept).

CONNECT: users with Connect permission can only log in to Oracle and cannot create entities (entities should be databases, data tables, fields, triggers, stored procedures, etc.), and database structures cannot be created.

For ordinary users: grant connect, resource permission.

For DBA administrative users: grant connect,resource, dba permissions.

Note: I am also a little vague about the concept of database structure and entity. My understanding of it is only a guess, and I have not found a detailed concept on the Internet. I hope the experts will be confused.

The specific permissions of each role can also be queried through the following sql statement

Select grantee,privilege from dba_sys_privs where grantee='RESOURCE' order by privilege;select grantee,privilege from dba_sys_privs where grantee='CONNECT' order by privilege;select grantee,privilege from dba_sys_privs where grantee='DBA' order by privilege

As shown in the figure: querying the permissions of the RESOURCE role

This is the end of the summary on the creation of user knowledge points, and there are still some deficiencies, I hope you can correct them.

Also attached in the cmd command framework, export, import database statements, please accept it, hey

Export statement and instance exp username / password @ server IP/ORCL file=e:\ 0202daochu.dmp owner= (username) exp myName/myPwd@127.0.0.1/ORCL file=e:\ 0202daochu.dmp owner= (myName) import statement and instance imp username / password @ server IP/ORCL ignore=y full=y file=e:\ 0202daochu.dmp log=e:\ log0202.log imp myName2/myPwd2@127.0.0.1/ORCL ignore=y full=y file=e:\ 0202daochu.dmp log=e:\ log0202.log

The above statement exports the database with the user name myName and generates the file 0202daochu on disk E.

And through the import statement, import the database content to the myName2 user, and generate a log file.

General operation flow: ctrl+r, cut out and run the program, enter cmd, and enter the above statement in the console. The following figure shows exporting the myName database.

Thank you for reading! On "Oracle database creation of users and database backup example analysis" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.