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

This article mainly shows you "how to use with admin option and with grant option in the database", the content is simple and clear, hoping to help you solve your doubts, let the editor lead you to study and learn "how to use with admin option and with grant option in the database" this article.

1 、 with admin option

With admin option means that the user granted this permission has the right to grant a permission (such as create any table) to another user or role, and cancellation is not cascading.

For example, An is granted system permission create session with admin option, and then A grants create session permission to B, but when the administrator withdraws A's create session permission, B still has the right of create session. However, the administrator can explicitly revoke the authority of B create session, that is, directly revoke create session from B.

2 、 with grant option

With grant option means: authorization is cascaded. For example, when with grant option is used for object authorization, the granted user can also grant this object permission to other users or roles. The difference is that when the administrator withdraws the user object permission authorized by with grant option, the permission will expire due to propagation. For example, grant select on table with grant option to An A user grants this permission to B, but when the administrator withdraws A's permission, the permission will expire. The permissions of B will also expire, but the administrator cannot directly revoke the SELECT ON TABLE permissions of B.

The above is all the contents of the article "how to use with admin option and with grant option in the database". 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.