Oracle User Concepts, Oracle user tablespaces, and Oracle User resource files

Oracle User Management

First, the concept of the user

Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts include schemas, permissions, roles, storage settings, space quotas, access resource constraints, database auditing, and so on. Each user has a password that uses the correct user/password to log on to the database for data access.

Second, user default table space

A tablespace is the largest logical unit of information storage, and when a user connects to a database for data storage, the data is stored in the user's default tablespace if the target storage table space is not indicated. For example: CREATE TABLE MyTable (ID varchar2 (), name VARCHAR2 (100)); This statement creates a table mytable and stores it in the current user's default tablespace, to specify a tablespace: Create Table MyTable (ID varchar2 (), name VARCHAR2 ()) tablespace tbs1;. The user's default tablespace can be specified when the user is created, or it can be specified using the Aler user command, as described later in this article.

Third, user temporary table space

Temporary table spaces are primarily used for ordering by statements and other intermediate operations. Before oracle9i, you can specify that users use a different temporary tablespace, starting at 9i, the temporary tablespace is generic and the user uses temp as a temporary tablespace.

Iv. User Resource Files

User resource files are used to restrict user access to resources, including CPU usage time limits, memory logical read limits, session data limits that each user can connect to, space and time limits for a session, duration limits for a session, and dedicated SGA space limits for each session.

Five, the user table space limit

Tablespace storage limits are the total amount of storage space a user can use in a table space. When creating or modifying a user, it can be indicated by the parameter quota. If a user exceeds this limit when they store data in a tablespace, an error occurs. Error messages such as: ' Ora-01536:space quota exceeded for tablespace tablespacename ... '. You can view the table space quota information by querying the dictionary Dba_ts_quotas.

Vi. Creating User resource Files

The syntax for creating user resource files is as follows:

CREATE profile filename LIMIT

Session_per_user integer

Cpu_per_session integer

User_per_call integer

Connect_time integer

......

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/