Oracle user creation and login

Oracle has three default customers

1. sys password change_on_install [as sysdba] 2. system password manager3 and Scott password tiger login with cmd: sqlplus/As sysdba

Create user: create user xiaokuidentified
Xiaoku; grant session permission: grant create sessionto xiaoku; grant table creation permission: grant create tableto xiaoku; grant tablespace permission: grant unlimited tablespaceto xiaoku;

In http: // localhost: 5560/isqlplus/login. uix, Scott's default password is tiger, Which is disabled by default.

SQL> conn / as sysdbaSQL> alter user SCOTT account unlock identified by tiger;User altered.SQL> select username,account_status from dba_users where username='SCOTT';USERNAME                       ACCOUNT_STATUS------------------------------ --------------------------------SCOTT                                OPENSQL> conn scott/tigerConnected.SQL> select * from tab;TNAME                          TABTYPE  CLUSTERID------------------------------ ------- ----------DEPT                             TABLEEMP                               TABLEBONUS                          TABLESALGRADE                   TABLE

After it is enabled, enter Scott in http: // localhost: 5560/isqlplus/login. uix and password tiger to log on. Enter the newly created xiaoku and the password xiaoku to log on.