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

There are two established users inside oracle: system and sys. Users can log in directly to the sys user to create other users, because sys has the right to create other users, why do you need to create a new user, mainly because the sys user authority is too large? if one day is not careful, the important information of production will be deleted, and the consequences will be very serious. Another is from the administrative point of view, a user is responsible for the data management of an application, as well as the control of permissions.

Creation syntax: create user username identified by password [that is, password]

Create user blt identified by pwdblt

Update syntax: alter user username identified by password [changed password]

Alter user blt identified by 123456

Delete syntax: drop user user name

Drop user blt cascade

If the user owns the object, it cannot be deleted directly, otherwise an error value will be returned. Specify the keyword cascade to delete all objects owned by the user, and then delete the user.

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.