Create and authorize an Oracle database user

First, log on to the database with sys or system user on the command line interface. The specific method is: 1) Run: cmd2) sqlplus → press Enter 3) sysassysdba → press ENTER → press enter to execute the SQL statement createuserusernameidentifiedbypassword; execute the authorized SQL statement: grantconnect, resource,

First, log on to the database using sys or system on the command line interface. The specific method is: 1) Run: cmd 2) sqlplus → press Enter 3) sys/as sysdba → press ENTER → press enter to execute the SQL statement: create user username identified by password; execute the authorized SQL statement: grant connect, resource,

First, log on to the database using sys or system on the command line interface. The specific method is as follows:

1) Run: cmd

2) sqlplus → press ENTER

3) sys/as sysdba → press ENTER

Run the following SQL statement to create a user:

Create user username identified by password;

Execute the authorized SQL statement:

Grant connect, resource, dba, exp_full_database, imp_full_database to username;

Oracle has multiple roles, and different roles have different permissions. Users can choose to grant different permissions as needed. For developers, developers need sufficient permissions.

The connect role has the following permissions: alter session, create cluster, create database link, create sequence, create session, create stnonym, create table, and create view.

The resource role has the following permissions: create cluster, create indextype, create operator, create procedure, create sequence, create table, create trigger, and create type.

Dba has all management Permissions

Exp_full_database is mainly used to export Oracle data.

Imp_full_database is mainly used for importing Oracle data.