[Oracle] Oracle Learning Summary (1)

1. View all users in the Oracle database:

(1) Log in to the database using an account with DBA authority;

(2) Execute select username from dba_users.

SQL>  conn sys input password: connected. SQL>Select from dba_users; USERNAME------------------------------mgmt_viewsyssystemdbsnmpsysmanscottoutlnflows _filesmdsysordsys

Here is a picture using the SELECT * from Dba_users query, in addition to the user name, we can see the account status (account_status), Table space Attribution (Default_tablespace), Login authentication Method (Authenaction_type) and other important information.

2. Unlock your account

sql> ALTER USER user_name Account UNLOCK;

3. Modify User Password

SQL>ALTERUSERuser_name by New_password;

4. View the currently logged in user

SQL>SELECTUSER from DUAL

Not to be continued ...

[Oracle]oracle Learning Summary (1)