Advertisement
ZUKMAN

Untitled

Oct 23rd, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. BEGIN
  2. BEGIN EXECUTE IMMEDIATE 'grant EXECUTE on fp_fnc_client_role to "PROGNOZ_USER" '; exception when others then if SQLCODE IN(-955, -1408) then null; else raise; end if; end;
  3. END;
  4. /
  5. BEGIN
  6. BEGIN EXECUTE IMMEDIATE 'grant EXECUTE on fp_fnc_client_role to "PROGNOZ_DBA" '; exception when others then if SQLCODE IN(-955, -1408) then null; else raise; end if; end;
  7. END;
  8. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement