Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JANUARY FEBRUARY 2018 127 SQL select table_ name 2 from dba_ tables 3 where owner SQL_ 201 4 order by table_ name TABLE_ NAME ANNUAL_ REVIEW DEPARTMENT EMPLOYEE EMPLOYEE_ CTAS EMPLOYEE_ EXTRA EMPLOYEE_ IDENTITY EMPLOYEE_ SUBSET 7 rows selected Listing 6 demonstrates how the WITH ADMIN OPTION privilege addition can be used to allow a user to pass system privileges on to others as well The BEYOND_ 101 user unsuccessfully attempts to create a sequence for a newly created table After the SYS user grants the SQL_ 201 user the ability to create sequences and pass such a privilege on to others the SQL_ 201 user grants the CREATE SEQUENCE system privilege to the BEYOND_ 101 user and the BEYOND_ 101 user is then able to successfully create a sequence
You must have JavaScript enabled to view digital editions.