Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE NOVEMBER DECEMBER 2017 103 GRANTEE GRANTED_ ROLE SQL_ 201 SYSTEM_ PRIVS_ FOR_ 201 SQL_ 201 RESOURCE SQL_ 201 CONNECT In Listing 11 because the SQL_ 201 user has not been granted the CREATE ROLE system privilege a privileged user must be used to create the SYSTEM_ PRIVS_ FOR_ 201 role Next the two system privileges already granted to the SQL_ 201 user are granted to the new role Finally the new role is granted to the SQL_ 201 user The query of DBA_ ROLE_ PRIVS confirms that the SYSTEM_ PRIVS_ FOR_ 201 role has been granted to the SQL_ 201 user This query also illustrates that the SQL_ 201 user has been granted two additional roles RESOURCE and CONNECT The queries in Listing 12 show which privileges have been granted to the RESOURCE and CONNECT roles Recall from the script you used to create the tables for the SQL_ 201 schema used for this articles examples that one of the statements executed was grant connect resource to sql_ 201 Listing 12 Display the system privileges granted to the CONNECT and RESOURCE roles SQL select grantee privilege 2 from dba_ sys_ privs 3 where grantee in CONNECT RESOURCE 4 order by grantee privilege
You must have JavaScript enabled to view digital editions.