Shulou(Shulou.com)06/01 Report--

I. the basic operation of the table

1. User management

1.1 users of the system in the initial state

Under system users, execute the following query statement to view all users of the current system

Select * from dba_users

1.2 create a user

SQL > create user xp identified by xp

User created.

Grant permissions to connect to the database:

SQL > grant connect to xp

Grant succeeded.

SQL > conn xp/xp

Connected.

1.3 unlock a user and change the password

SQL > alter user hr account unlock

User altered.

SQL > alter user hr identified by hr

User altered.

1.4 deleting a user

SQL > conn / as sysdba

Connected.

SQL > drop user xp;-users can delete objects without creating objects

Drop user xp

*

ERROR at line 1:

ORA-01922: CASCADE must be specified to drop 'XP'

SQL > drop user xp cascade;-- user cascading deletes all user-related objects

User dropped.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.