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

The situation of reporting an error is as follows

A user: view Vitera

B user: view VroomB, and Vrooma is used

C user: need to use VroomB

Authorization process

A user:

Grant select on V_A to B

B user:

Grant select on V_B to C

An error is reported at this time: the ora-01720 authorization option does not exist for 'Vega'.

So what is the reason? because B also needs to authorize views to C users, but the views used by B are under A, so in addition to granting select permissions to B, you should also authorize operation rights.

For example, you need to grant grant operation rights to B under user A, so that B can continue to authorize C. As follows:

A user:

Grant select on V_A to B with grant option

B user:

Grant select on V_B to C

This is the right time. VroomB can be used normally in C #.

Similarly, if C wants to continue to authorize, then user B should also be authorized accordingly.

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.