Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 can be granted to a user via GRANT keyword syntax similar to that used for granting privileges Consider the example in Listing 11 Listing 11 Collect system privileges into a role and grant the role to users SQL connect as sysdba Connected SQL alter session set container bynd ORACLE MAGAZINE NOVEMBER DECEMBER 2017 102 Session altered SQL CREATE ROLE system_ privs_ for_ 201 Role created SQL grant create user select any dictionary to system_ privs_ for_ 201 Grant succeeded SQL grant system_ privs_ for_ 201 to sql_ 201 Grant succeeded SQL select grantee granted_ role 2 from dba_ role_ privs 3 where grantee SQL_ 201
You must have JavaScript enabled to view digital editions.