WebUsing the WITH ADMIN OPTION clause of the GRANT (Role) SQL statement, the security administrator can delegate the management and control of membership in a role to someone else. The WITH ADMIN OPTION clause gives another user the authority to grant membership in the role to other users, to revoke membership in the role from other … WebIn this example, the GRANT statement gives user PSD SELECT privilege on the demoempl.employee table, as well as the authority to assign that privilege to other users: ... Omitting WITH GRANT OPTION. If you omit WITH GRANT OPTION when you grant a definition or access privilege, the named users receive the definition or access privilege, …
oracle - ORA 01031 Insufficient privileges on GRANT …
http://www.dbarepublic.com/2016/05/with-grant-option.html WebNov 18, 2010 · As user A: GRANT select ON table TO user_b WITH GRANT OPTION; Let user B grant select on his views to user A and include the 'grant option'. As user B: GRANT select ON view TO user_a WITH GRANT OPTION; As user A: GRANT select on user_b.view TO user_c; This allows user A to pass this grant on to other users. Share. greensboro city council meeting agenda
GRANT … AS: Using GRANT … WITH GRANT OPTION for …
WebSep 20, 2016 · 1. A ‘select any table’ privilege is granted to ROLE1 with admin option connect /as sysdba grant select any table to ROLE1 with admin option; 2. Grant ROLE1 to USER1 irrespective of whether you grant it w/ or w/o admin option connect /as sysdba grant ROLE1 to USER1; 3. Can USER1 now grant 'select any privilege' to other users? WebSpartan Chemical Company. Jun 2024 - Present3 years 11 months. Fort Wayne, Indiana, United States. At Spartan Chemical Company, we … WebIf you then grant the SELECT privilege on the database and specify WITH GRANT OPTION, that user can give to other users not only the SELECT privilege, but also … greensboro city council meeting