When A user permissions to users, B B users and pass these permissions to C,
Back when A user is passed to the users of these privileges, B C whether the user has the permission? (if A user is administrator user, or A regular user, what's the difference?)

CodePudding user response:

C permissions will be recycled,

CodePudding user response:

C without permission, can be retrieved

CodePudding user response:

B to C permissions are made from A to B, B, C there will be no more

CodePudding user response:

If the database administrator use GRANT commands A award system permissions to users is with WITHADMINOPTION option, then the users again awarded B; If at the moment the database administrator use REVOKE command to cancel A user's system permissions, user B system permissions still effective,