Granting SYS_AUTH_WRITECLIENTFILE

Grant to allow users to write to a file resident on the client machine.

Prerequisites

Administrative privilege over SYS_AUTH_WRITECLIENTFILE_ROLE.

Task

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

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

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

Administrative Option

Statement

With full administrative rights

GRANT ROLE SYS_AUTH_WRITECLIENTFILE_ROLE TO user_ID

WITH ADMIN OPTION

With administrative rights only

GRANT ROLE SYS_AUTH_WRITECLIENTFILE_ROLE TO user_ID

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT ROLE SYS_AUTH_WRITECLIENTFILE_ROLE TO user_ID

WITH NO ADMIN OPTION

Example:

This example grants the SYS_AUTH_WRITECLIENTFILE_ROLE to Mary, with only administrative options.

GRANT ROLE SYS_AUTH_WRITECLIENTFILE_ROLE TO Mary WITH ADMIN ONLY OPTION

Granting SYS_AUTH_WRITECLIENTFILE_ROLE