Oracle Magazine, Jan/Feb 2018
Database Application Developer and DBA BEYOND SQL 101 Limited Profiles and Private References Part 13 in a second series on the basics of the relational database and SQL This article is the thirteenth and last in a series that helps you build on the fundamentals that you learned in the 12 part SQL 101 series in Oracle Magazine The previous Beyond SQL 101 article Becoming Privileged and Creating Synonymously taught you how to create alter and drop users and how users relate to schemas You learned what system privileges and object privileges are and how privileges are granted and revoked Additionally you saw that roles are collections of privileges that can be granted and revoked in a similar fashion as individual privileges Lastly you witnessed how privileges and roles should be granted on a discretionary as needed basis for security and ease of administration ORACLE MAGAZINE JANUARY FEBRUARY 2018 115 ORACLE DATABASE By Melanie Caffrey
You must have JavaScript enabled to view digital editions.