Oracle Introduction Oracle First chapter 1-4 Oracle User Management

1.Oracle Default User
Access to Oracle database only with a legitimate user account
Oracle has several default database users

All data dictionary tables and views in the database are stored in the SYS pattern. SYS users are primarily used to maintain system information and manage instances.
Systems is the default system administrator who owns the internal tables and views used by Oracle management tools. Typically manage database users, permissions, and storage through system users
The Scott user is a demo account of the Oracle database that was created when the database was installed

2. Create a new user

To connect to an Oracle database, you need to create a user account
Each user has a default tablespace and a temporary table space
The Create user command is used for creating new users

　　

--table space Creation SyntaxCreatetablespace table space name DataFile'file path'Size file Autoextend on|off(whether auto-growth)--Example: Create a 1605NACreatetablespace 1605NAdatafile'E:\db\1605NA. ORA'size 10mautoextend on--Create a temporary table spaceCreate Temporarytablespace table space name Tempfile'file path'Size file Autoextend on|off(whether auto-growth)--ExampleCreate Temporarytablespace tm1605natempfile'E:\db\tm1605NA.ORA'size 10mautoextend on--Create a user's syntaxCreate UserUser name identified byPassworddefaulttablespace default table spaceTemporarytablespace temporary table space--Example: Create a userCreate Usertszsidentified by 123defaulttablespace 1605NATemporaryTablespace Tm1605na

3. Granting permissions

Permission refers to the right to execute a specific command or access a database object
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 that is a system privilege
Object permissions allow users to perform specific operations on database objects such as tables, views, sequences, and so on
A role is a combination of related permissions that can be granted to a role and then granted to a user to simplify rights management.

--granting Permissions--categorize individual permissions or roles--Login PermissionsGrantConnect toTszs--giving permissions to create tablesGrant Create  Table  toTszs--Assigning DBA RolesGrantDba toTszs--Reclaim PermissionsRevokePermission Name fromUser nameRevokeDba fromTszs--Delete User--There are no database objects under this userDrop UserUser nameDrop UserTszs--To delete a storage database objectDrop UserUser nameCascadeDrop UserTszsCascade--Lock UserAlter UserTszs Account Lock--Unlocking UsersAlter UserTszs Account Unlock

The first chapter summarizes

Oracle servers are made up of Oracle databases and Oracle instances
The Oracle instance consists of the system global memory structure and the background process used to manage the database
The primary query tool for accessing databases in Oracle is Sql*plus, isql*plus, and PL/SQL
Oracle Enterprise Manager is a tool for managing, diagnosing, and tuning multiple databases
SYSTEM Users and SYS users in Oracle have administrative privileges, and SCOTT users have only basic permissions
Oracle services are registered in the Windows registry and are managed by the Windows operating system

Oracle Introduction Oracle First chapter 1-4 Oracle User Management