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

Was this helpful?