Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- l_roles OWA.VC_ARR;
- l_modules OWA.VC_ARR;
- l_patterns OWA.VC_ARR;
- BEGIN
- l_roles(1) := 'SQL Developer';
- l_patterns(1) := '/users/*';
- ORDS.DEFINE_PRIVILEGE(
- p_privilege_name => 'rest_privilege',
- p_roles => l_roles,
- p_patterns => l_patterns,
- p_modules => l_modules,
- p_label => '',
- p_description => '',
- p_comments => NULL);
- COMMIT;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement