Oracle Learning Notes User Management-2

Case: Create a user software and assign permissions, you can have software log in to the database, create tables, manipulate tables that you create, reclaim roles, and finally delete users.

1. Create software user, password system

Create user software identified by system;

2, let software connect the database, need to give it connect, resource permissions

Grant connect to Software;

Grant resource to Software;

3. Login with software user

conn Software/[email protected];

4. Create a table

CREATE table users (ID number);

Insert into users values (1);

select * from Users;

5. Switch to admin system, delete software user

conn System/[email protected];

Drop user software cascade; ---when software has its own data object, add cascade and delete the user-owned data object

6, can lock the user first, view the data object after deleting

Alter user software account lock;