Tutorial: Oracle 11g OCP path (8): user permission management

Preface

In this section, we need to clarify three concepts: users, permissions, and roles.

Create user

Two concepts are introduced in this example. 1. Users: We create users. Of course, this concept of users is introduced. 2. Permission. connection failed because we do not have the create session permission. The first SQL statement is to create a test user whose password is test. This is the simplest command to create a user. We will authorize again.

The concepts of users and permissions are well explained. A role is a package of permissions. How do I feel like it is over? I tried to give it a little more details.

User

User attributes: User Name, authentication method, default tablespace, temporary tablespace, user configuration file, and account status. In fact, I think the most important sentence is this sentence, especially for beginners.

Many people forget to graphically unlock scott users. When scott wants to use it, he finds that he is at a loss. Of course, why are these user attributes that can be specified when a user is created. How to specify it.

Permission

How many permissions does the database system have? System permissions: GRANTSystem_privilege TOUser_name [ WITH ADMIN OPTION]; REVOKESystem_privilege FROMUser_name;

Object permission:

GRANTObject_privilege ONObject_name TOUsername [ WITH GRANT OPTION]; REVOKEObject_privilege ONObject_name FROMUsername;

Role

Common system roles. Similarly, you can create custom roles by yourself.

Conclusion

The more the article is written, the more water it is written. There are several reasons. 1. eager for success. I really want to complete a series and prove my persistence. Therefore, I have put a lot of content in one chapter. The consequence of this is that many of them are unavailable in the east and west regions, there are several concepts left after the association is simplified and simplified. 2. I lack the ability to write a good blog. In this respect, I can only read more blog posts.