Using the grant Command's granted by Option

Usage information for using the grant command's granted by option.

  • granted by is not allowed on granting predicated privileges.

  • It is not required that the grantor has permission to execute the grant command.

  • The grantor, and not the command executor, is listed under sysprotects.grantor.

  • You need not enable enable granular permissions to use the granted by parameter.

  • Users who received their grant permission on an object with the with grant option cannot issue the granted by parameter. All other users may issue the granted by parameter.

    For example, if Mary grants select on her table books to John with the with grant option, then John gets an error when he tries to issue the second grant command. Mary:

    grant select on mary.books 
    to john with grant option
    grant select on mary.books 
    to joe granted by smith