Oracle Learning Notes User Management-1

SYS System (Administrator)

Scott (normal user)

SQL Server SA

Premise: Oracle, if you are an administrator, when the need to establish a user, the operation by themselves;

1. Create User (SYS system user)

Create user username identified by password;

Note: Passwords cannot start with a number

Create user mmy identified by system;

Created by the Mmy user, and cannot be logged in immediately via Conn, the following step is required

2, give users the appropriate permissions

Grant create session to Mmy;

Conn Mmy/[email protected] You can log in

3, the complete creation of users

Create user username identified by UserPassword

Default Tablespace users---defaults table space users

Temporary tablespase temps---temporary tablespace temps

Quota 3M on user; No more than 3M of data objects on the---table space