Explanation
The execution of this REVOKE statement would have side effects such as the revocation of other privileges or the dropping of views, and the word CASCADE is required in that case.
The SQLSTATE that equates to this SQL return code is 53S24.
User Response
If the automatic cascading of revokes and drops is acceptable, change the statement to include CASCADE and reexecute. If automatic cascading is not desired, the statement may not be executed until there would be no cascading effects. The automatic cascading actions are necessary to prevent the possibility of security breaches.
|
Copyright © 2014 CA.
All rights reserved.
|
|