Granting SYS_AUTH_WRITEFILE

Allows users to write to a file that is resident on the server machine.

Prerequisites

Administrative privilege over SYS_AUTH_WRITEFILE_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 role, execute one of the following statements:

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

Administrative Option

Statement

With full administrative rights

GRANT ROLE SYS_AUTH_WRITEFILE_ROLE TO user_ID

WITH ADMIN OPTION

With administrative rights only

GRANT ROLE SYS_AUTH_WRITEFILE_ROLE TO user_ID

WITH ADMIN ONLY OPTION

With no administrative rights

GRANT ROLE SYS_AUTH_WRITEFILE_ROLE TO user_ID

WITH NO ADMIN OPTION

Example:

This example grants the SYS_AUTH_WRITEFILE_ROLE to Mary, with no administrative rights.

GRANT ROLE SYS_AUTH_WRITEFILE_ROLE TO Mary WITH NO ADMIN OPTION

Granting SYS_AUTH_WRITEFILE_ROLE