SHARE
TWEET

Untitled

a guest Jul 19th, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE
  2.  l_roles     OWA.VC_ARR;
  3.  l_modules   OWA.VC_ARR;
  4.  l_patterns  OWA.VC_ARR;
  5. BEGIN
  6.  l_roles(1)   := 'SQL Developer';
  7.  l_patterns(1) := '/users/*';
  8.  ORDS.DEFINE_PRIVILEGE(
  9.      p_privilege_name => 'rest_privilege',
  10.      p_roles          => l_roles,
  11.      p_patterns       => l_patterns,
  12.      p_modules        => l_modules,
  13.      p_label          => '',
  14.      p_description    => '',
  15.      p_comments       => NULL);
  16.  COMMIT;
  17.  
  18. END;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top