SQL *Plus, SQL Developer User & Table Management: Grant User SYSDBA Privilege in SQL Developer

by Köll Cherizard, Dököll Solutions

In this session, we are creating user roles and secure pages tables. Our user roles table will have ten defined roles, ranging from Author, Browser, Designer, etc... with a description to each role. The secure pages table will contain web page names and file names associated with each user role. We are writing a complete set of Oracle database scripts via the SQL Developer to manage the user roles and the secure pages. We will run SQL *Plus Command-line scripts to create tables beforehand, then we will branch off to SQL Developer. This will be a big first step, it will get us closer to storing eBooks in the ORA_DEV back-end. We will be joining multiple tables together (via Unique IDs) to grab specific data, with specific roles. Be prepared for a lengthy session, and as usual, all areas of interest will be highlighted for your convenience.

64 pages, Kindle Edition

Published May 11, 2021