Common oracle-sqlplus commands and user management

1. Common commands

1) linesize the number of characters displayed per line

2) pagesize: number of lines displayed per page

2. Basic oracle usage, user management, and table management

Advanced: Table query, permissions and roles, functions, pl/SQL programming, database management, indexing and constraints and transactions

3. User Management

1) create user XXX identified by XXX;

2) a tablespace is the space in the table. A tablespace points to a specific data file;

3) create user XXX identified by XXX

Default tablesapce users

Temporary tablespace temp

Quota 3 m on users

4) A User just created does not have the logon permission and needs to be authorized:

Grant create session to XXX;

4. Permissions

System permissions: 128 types of create session/table/index/view/sequence/trriger

Object permission: update/insert/delete/select