Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE NOVEMBER DECEMBER 2017 92 SQL grant select any dictionary to sql_ 201 Grant succeeded Reconnect as SQL_ 201 to continue this articles exercises SQL connect sql_ 201@ bynd Enter password Connected SQL select privilege 2 from user_ sys_ privs 3 order by privilege PRIVILEGE CREATE USER CREATE VIEW SELECT ANY DICTIONARY To grant the CREATE USER system privilege to the SQL_ 201 user you must be logged in to the database as a privileged user with the ability to grant this privilege to another user Listing 3 demonstrates that the SYS user has the ability to grant that privilege to the SQL_ 201 user Using the command connect as sysdba
You must have JavaScript enabled to view digital editions.