Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 Code Listing 6 A user granted the WITH ADMIN OPTION privilege addition can pass a system privilege to another user SQL create table test_ me id number ORACLE MAGAZINE JANUARY FEBRUARY 2018 128 Table created The BEYOND_ 101 user has not been granted the ability to create a sequence SQL create sequence test_ me_ seq create sequence test_ me_ seq ERROR at line 1 ORA 01031 insufficient privileges SQL connect as sysdba Connected SQL alter session set container bynd Session altered SQL grant create sequence to sql_ 201 WITH ADMIN OPTION Grant succeeded SQL connect SQL_ 201@ bynd Enter password Connected
You must have JavaScript enabled to view digital editions.