Shulou(Shulou.com)05/31 Report--

Editor to share with you an example of ORACLE user rights management analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Today, let's take a look at the user rights management of ORACLE. Creating new users can only be a matter for oracle's DBA manager.

Statement: Create user TestUser identified by testPass; where TestUser is the user name and testPass is the password

Change the password (the DBA manager or the user can use the alter statement)

Statement: Alter user TestUser identified by newtestPass; only needs to change Create to Alter, the user name, followed by a new password

If a user is not logged in to the plsql application, an error will be reported, and there is an important link here, that is, to assign permissions.

The image above means that test users do not need to grant connection permissions (Create Session keyword), grant permissions (Grant)

Statement: Grant Create Session to test

Beginners only need to grant the following permissions:

Permission meaning Create table gives permission to create table Create view gives permission to create view Create procedure gives permission to create process Create sequence gives permission to create sequence

There is also a kind of object permission: (that is, what kind of permission can be assigned to the specified user?

Different objects have different object permissions

The owner of the object has all permissions

The owner of the object can assign permissions to the outside

Query, update, add, etc., of allocation table oll. Authority

~ statement 1:Grant Select, Update on oll to test; statement 2:Grant Select, Update on oll to test with grant option; statement 3:Grant Select, Update on oll to public; ~

Statement 1: just give the permissions of Select and Update of the oll table to the test user.

Keywords are ~ (with grant option)

Statement 2 is different from statement 1 by adding the keyword with grant option, which means that test users also have the right to assign Select and Update of the oll table to other users.

Keywords are (public)

The statement 3 keyword (public) means common. As long as the user uses public for the permissions of Select and Update of the oll table

That is, all users can use the data of oll table.

If you can assign permissions to an object, you can take back the permissions of the object, keyword (revoke).

If the revoke statement is used, even the permissions assigned by using the with grant option clause will be revoked

It means that the permissions equivalent to the oll table are assigned to test, while test users have permissions assigned to other users, and the revoke statement

Reclaiming the privileges of the test user is also equivalent to withdrawing the permissions assigned by test to others.

Statement: Revoke Select, Update on oll from test

User lock unlock and password invalidation

Command line: ALTER test USER ACCOUNT LOCK/UNLOCK; Lock means locked. UnLock has no lock.

Delete user (drop)

Sentence: drop user test; the above is all the content of this article "sample Analysis of ORACLE user Rights Management". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.