Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 CONCLUSION This article taught you more about object privileges You learned how to grant them and how grantees might need to qualify an object name with its schema name in order to take advantage of their granted access Additionally you explored the difference between public and private synonyms and why it is good practice to defer to using private synonyms in your application code You discovered how to extend privileges to others when privileges have been granted with the WITH GRANT OPTION or WITH ADMIN OPTION options Lastly you saw how profiles are used to limit a users resource and password settings This article concludes the Beyond SQL 101 series Youve learned basic relational database concepts and many SQL coding constructs beyond those discussed in the SQL 101 series Be sure to continue to read the documentation and try existing and new Oracle Database features Thank you for being readers of Oracle Magazine and of the Beyond SQL 101 series As you continue writing SQL my hope is that you enjoy it as much as I do Melanie Caffrey is a senior development manager at Oracle She is a coauthor of Beginning Oracle SQL for Oracle Database 12c Apress 2014 Expert PL SQL Practices for Oracle Developers and DBAs Apress 2011 and Expert Oracle Practices Oracle Database Administration from the Oak Table Apress 2010 ORACLE MAGAZINE JANUARY FEBRUARY 2018 134 PHOTOGRAPHY BY RAY NG NEXT STEPS READ SQL 101 Parts 1 12 READ more Beyond SQL 101 LEARN more about relational database design and concepts
You must have JavaScript enabled to view digital editions.