Oracle creates users, authorizes users, creates tables, queries tables

Original: Oracle create user, authorize user, create TABLE, query table

Oracle creates users, authorizes users, creates tables, queries tables

Assuming that all of the oracle10g have been installed and configured.

The first step: Win+r, enter run, CMD;

The second step: Connect Super Administrator SYSDBA, statement sqlplus/as SYSDBA;

The third step: (Assuming the connection is successful) input Conn/as sysdba;

Fourth Step: (Display connection succeeded) create user bony identified by b123;

Fifth step: Grant Resource,connect to Bony;

Sixth step: Conn bony/b123;

Seventh Step: Create TABLE CCTV (name varchar, age integer);

Eighth step: INSERT into CCTV values (' CCTV ', 28);

Eighth Step: SELECT * from CCTV;

Let's get to it today.

CTRL + C exits the database connection.

Oracle creates users, authorizes users, creates tables, queries tables