Grant to allow users to manage data privileges, groups, authorities, and passwords.
Administrative Option | Statement |
---|---|
With full administrative rights |
GRANT ROLE SYS_AUTH_PERMS_ADMIN_ROLE TO user_ID WITH ADMIN OPTION |
With administrative rights only |
GRANT ROLE SYS_AUTH_PERMS_ADMIN_ROLE TO user_ID WITH ADMIN ONLY OPTION |
With no administrative rights |
GRANT ROLE SYS_AUTH_PERMS_ADMIN_ROLE TO user_ID WITH NO ADMIN OPTION |
This example grants the SYS_AUTH_PERMS_ADMIN_ROLE to Mary, with only administrative options.
GRANT ROLE SYS_AUTH_PERMS_ADMIN_ROLE TO Mary WITH ADMIN ONLY OPTION