Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 In this article you will Learn how to create alter and drop users and schemas Discover the difference between system privileges and object privileges See how to GRANT and REVOKE privileges Get an introduction to roles To try out the examples in this series you need access to an Oracle Database instance If necessary download and install an Oracle Database edition for your operating system I recommend installing Oracle Database Enterprise Edition 12c Release 2 122010 If you install the Oracle Database software choose the installation option that enables you to create and configure a database A new database including sample user accounts and their associated schemas will be created for you Note that SQL_ 201 is the user account to use for the examples in this series its also the schema in which youll create database tables and other objects When the installation process prompts you to specify schema passwords enter and confirm passwords for the SYS and SYSTEM users and make a note of them Finally whether you installed the database software from scratch or have access to an existing Oracle Database instance download unzip and execute the SQL script to create the tables for the SQL_ 201 schema used for this articles examples View the script in a text editor for execution instructions A NAMED COLLECTION For the examples in this seriess articles you log in to the Oracle Database instance as a database user SQL_ 201 to create objects such as tables views indexes and sequences and then populate or manipulate these objects The collection of objects a user creates and maintains is known as a schema This articles SQL_ 201 user owns the SQL_ 201 schema the user and schema name are the same Because each ORACLE MAGAZINE NOVEMBER DECEMBER 2017 88
You must have JavaScript enabled to view digital editions.