Function returns “Y” if role with the given name found in the database, otherwise return “N”

Note: Oracle only

Arguments

  • v_RoleName – name of the role to be found

 

Examples

Oracle

SELECT DBTD_IS_ROLE_FOUND('webapp_read_ony_role') AS IS_ROLE_FOUND FROM DUAL;

 

See Also