User with the CREATE COMPUTE PROFILE WITH GRANT OPTION Privilege
This statement grants the CREATE COMPUTE PROFILE privilege to the SysDBA user.
GRANT CREATE COMPUTE PROFILE TO SysDBA WITH GRANT OPTION;
*** Grant accepted.
User with the DROP COMPUTE PROFILE WITH GRANT OPTION Privilege
This statement grants the DROP COMPUTE GROUP privilege to the CloudDBA user.
GRANT DROP COMPUTE PROFILE TO CloudDBA WITH GRANT OPTION;
*** Grant accepted.