Shulou(Shulou.com)06/01 Report--

1.Oracle default users can only access the Oracle database with a legitimate user account Oracle has several default database users

two。 To connect to an Oracle database, you need to create a user account that each user has a default tablespace and a temporary tablespace classification.

Permanent tablespace: stores permanent data, such as tables, indexes, etc.

Temporary tablespace: cannot store permanent objects, which can be used to store temporary data generated by database sorting and grouping

2.2 create tablespaces

Tablespace: a tablespace is a logical partition of a database, and a tablespace can only belong to one database. All database objects are stored in the specified tablespace. But tables are mainly stored, so they are called tablespaces.

2.2.1 create a data tablespace create tablespace user_data logging datafile'D:\ oracle\ oradata\ user_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local 2.2.2 create temporary tablespace create temporary tablespace user_temp2tempfile 'D:\ oracle\ oradata\ user_temp1.dbf'size 50mautoextend onnext 50m maxsize 20480mextent management local2.3 create user create user etc-username identified by "admin"-password default tablespace user_data-data tablespace temporary tablespace user_temp1-temporary tablespace 2.3user unlock

Alter user user name account unlock

3 Grant permissions 3.1 Grant permissions refers to the right to execute specific commands or access database objects. There are two types of permissions, system permissions and object permissions.

System permissions allow users to perform certain database operations, such as creating a table is a system permission

Object permissions allow users to perform specific operations on database objects (such as tables, views, sequences, etc.)

A role is a combination of related permissions that can be granted to a role and then to a user to simplify permission management. 3.2 3 standard roles

Qracle provides three standard roles (role) to be compatible with previous versions: CONNECT, RESOURCE, and DBA

CONNECT Role (connection role)

Temporary users, especially those who do not need to create tables, are usually only given CONNECTrole. CONNECT is a simple permission to use Oracle, which makes sense only if you have access to other users' tables, including select, insert, update, delete, and so on. Users with CONNECT role can also create tables, views, sequences (sequence), clusters (cluster), synonyms (synonym), sessions (session), and chains with other databases (link).

RESOURCE Role (Resource role)

More reliable and formal database users can be awarded to RESOURCE role. RESOURCE gives users additional permissions to create their own tables, sequences, procedures (procedure), triggers (trigger), indexes (index), and clusters (cluster)

DBA Role (Database Administrator role)

DBA role has all the system permissions-including unlimited space limits and the ability to grant various permissions to other users. The SYSTEM is owned by the DBA user. Here are some typical permissions that are commonly used by DBA.

3.3 Grant permissions

The GRANT command can be used to assign permissions or roles to users

Give system permissions: grant role to user

Give object permissions: Grant insert update delete select on table to user

Reclaim system permissions: revoke role from user

Reclaim object permissions: revoke all on table from user

Change: ALTER USER MARTIN IDENTIFIED BY martinpass; (change password)

Deleting: drop user user

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.