Oracle Database Security Interview Questions, Answers, and Explanations: Oracle Database Security Certification Review

Oracle Database Security Interview Questions, Answers, and Explanations

EQUITY PRESS

Oracle Database Security Interview Questions, Answers, and Explanations

ISBN 978-1-60332-008-5

Smashwords Edition

Copyright© 2006 Equity Press and ORA COOKBOOK all rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording or otherwise) without either the prior written permission of the publisher or a license permitting restricted copying in the United States or abroad.

The scanning, uploading and distribution of this book via the internet or via any other means with the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions, and do not participate in or encourage piracy of copyrighted materials.

The programs in this book have been included for

instructional value only. They have been tested with

care but are not guaranteed for any particular purpose.

The publisher does not offer any warranties or

representations nor does it accept any liabilities with

respect to the programs.

Trademarks: All trademarks are the property of their respective owners. Equity Press is not associated with any product or vendor mentioned in this book.

Please visit our website at www.oracookbook.com

REGISTER YOUR BOOK

You are entitled to FREE UPDATES for Oracle Security Interview Questions, Answers, and Explanations – as well as discounts on all Equity Press books and Information Technology career preparation materials.

Please visit http://www.oracookbook.com/register

TABLE OF CONTENTS

Question 1: Grant to Select Session Details

Question 2: Username with @

Question 3: SELECT access to VIEWS through ROLES

Question 4: Audited Objects

Question 5: user_ts_quotas

Question 6: Trigger to Prevent Any User to Login

Question 7: demobld

Question 8: Alter Username

Question 9: DBA Role

Question 10: Delete the user’s name

Question 11: Restricted User Role

Question 12: Forget Sys and System Password

Question 13: Decrypt Password Field

Question 14: Password and Login Feature

Question 15: Unable to Use Connect-Time

Question 16: History of Passwords

Question 17: Security auditing in Oracle 10g One

Question 18: Check all Privilege Available

Question 19: ORA-01017

Question 20: DMP Help

Question 21: Schema which only selects tables

Question 22: Set connect as sysdba?

Question 23: Unlock an Account

Question 24: Security of SYS AS SYSDBA Password

Question 25: DDL

Question 26: Solaris 9 10g

Question 27: Security Oracle when using the Internet

Question 28: Password doesn't work for SYSDBA

Question29: Keeping a history of the V$SESSION

Question 30: Exp/Imp Security

Question 31: Missing Roles

Question 32: Any Password works

Question 33: Lost Password

Question 34: AUDIT_ACTIONS Table

Question 35: SYSDBA Login

Question 36: Sys Password

Question 37: ORA-28001

Question 38: Finding Database

Question 39: Wrap Multiple Files

Question 40: Verifying Security Patches

Question 41: Password Expires Soon

Question 42: Create Package/Trigger Privileges

Question 43: Directory and Creating Directory Rights

Question 44: Table Access Query

Question 45: Restricted Access in Oracle

Question 46: Rule/format for the username and password

Question 47: Adding a User

Question 48: Database Security through Roles

Question 49: Creating role with password

Question 50: Audit Trail

Question 51: Password Problem

Question 52: Change password of Sysdba

Question 53: Delete a User

Question 54: Security

Question 55: External Authentication

Question 56: Recovering the sys password

Question 57: Grant Privileges

Question 58: Automatic password expiration

Question 59: Cannot populate audit log table

Question 60: Role needed to get over the problem

Question 61: Problem after changing password

Question 62: Connectivity: SQL*Net and Security

Question 63: New role object privileges

Question 64: audit parameter not working

Question 65: Create role

Question 66: Issue with fine grain policies

Question 67: Privilege to a user

Question 68: Trigger auditing in Ora 8.1.7.4.1

Question 69: Role to give user to load data

Question 70: Revoking all permissions from user

Question 71: Password decryption

Question 72: Password capture

Question 73: sysdba/resource privilege

Question 74: Audit sql statement

Question 75: Mixing letters and numbers in passwords

Question 76: Not able to Grant Write Permission

Question 77: DBMS_OBFUSCATION_TOOLKIT

Question 78: ROLES/PRIVS

Question 79: Audit user activities in database

Question 80: Impact in locking the account Scott

Question 81: Disable audit

Question 82: DEFAULT PASSWORDS

Question 83: Roles Question

Question 84: Audit Trail

Question 85: Oracle system created DBA

Question 86: Forgot password

Question 87: Authentication in Stored Procedure

Question 88: GRANT inside procedure

Question 89: Grant execute privileges

Question 90: Trigger code for audit columns

Question 91: DBMS_OBFUSCATION_TOOLKIT

Question 92: UserName, Password and Host String

Question 93: Error in pl/sql and encryption

Question 94: PL/SQL Random Password Generator

Question 95: Checking Oracle