Remote procedure calls

Syntax for authorizing remote procedure calls.

Syntax for authorizing remote procedure calls use the following modelled hierarchy:

  • ALL REMOTE CALLS
    • REMOTE OBJECT object_name
      • REMOTE METHOD object_name.method_name

Synopsis

Use the following syntax when granting permission on remote procedure calls:
  • ALL REMOTE CALLS
    GRANT permission_list 
ON ALL REMOTE CALLS 
TO role_name;
    where permission_list is a comma separated list that can include ALL PERMISSIONS, AUTHORIZE [FOR permission_list], EXECUTE, MODIFY, and SELECT
  • REMOTE OBJECT object_name
    GRANT permission_list 
ON REMOTE OBJECT object_name 
TO role_name;
    where permission_list is a comma separated list that can include ALL PERMISSIONS, AUTHORIZE [FOR permission_list], EXECUTE, MODIFY, and SELECT
  • REMOTE METHOD object_name.method_name 
    GRANT permission_list 
ON REMOTE METHOD object_name.method_name 
TO role_name;
    where permission_list is a comma separated list that can include ALL PERMISSIONS, AUTHORIZE [FOR permission_list], EXECUTE, MODIFY, and SELECT