Granting SYS_AUTH_READCLIENTFILE

Allows users to read to a file that is resident on the client machine.

Prerequisites

Administrative privilege over SYS_AUTH_READCLIENTFILE_ROLE.

Task

You can grant this role with or without administrative rights. When granted with administrative rights, you can manage (grant and revoke) the role, as well as use any of the underlying system privileges. When granted with administrative rights only, you can manage the role, but not use its underlying system privileges. Finally, when granted with no administrative rights, you can only use its underlying system privileges.

To grant the SYS_AUTH_READCLIENTFILE_ROLE role, execute one of the following statements:

Administrative Option	Statement
With full administrative rights	GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO `user_ID` WITH ADMIN OPTION
With administrative rights only	GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO `user_ID` WITH ADMIN ONLY OPTION
With no administrative rights	GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO `user_ID` WITH NO ADMIN OPTION

Administrative Option

Statement

With full administrative rights

GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO user_ID

WITH ADMIN OPTION

With administrative rights only

GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO user_ID

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO user_ID

WITH NO ADMIN OPTION

Example:

This example grants the SYS_AUTH_READCLIENTFILE_ROLE to Mary, with only administrative rights.

GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO Mary WITH ADMIN ONLY OPTION

Granting SYS_AUTH_READCLIENTFILE_ROLE