DBASupport

Explicit GRANTs and ROLES in Oracle Database 11g
Many database shops have no idea of the security breaches that occur across user granted privilege and floating unused synonyms. James Koopmann offers tips for granting privileges explicitly to a user or group of users, and assigning privileges to a role and then granting... that role to users.

View story | View all stories | About Social RSS | Join Social RSS

Explicit GRANTs and ROLES in Oracle Database 11g
Many database shops have no idea of the security breaches that occur across user granted privilege and floating unused synonyms. James Koopman offers tips for granting privileges explicitly to a user or group of users, and assigning privileges to a role and then granting ...that role to users.

View story | View all stories | About Social RSS | Join Social RSS

Product Review: Toad for Data Analysts
Toad for Data Analysts (TDA) is yet another product in a long line of highly useful, well-designed, productivity enhancing applications. The branding behind the purpose of this tool gets right to the heart of what TDA can help you accomplish with data: Query, Understand, and Report....

View story | View all stories | About Social RSS | Join Social RSS

Protecting Data from Users
What is the best way to prevent unintended updates or deletes in a table? The small changes may not be so hard to recover from, but what if every record in the table underwent a change? How can you protect users from themselves and how do you protect yourself from you?

View story | View all stories | About Social RSS | Join Social RSS

Oracle 11g Security The Power of PROFILES
Using profiles for password management is an effective way to restrict unsolicited database usage. Every DBA should verify the password restrictions and setup an appropriate number of profiles for the groups or types of users within the database.

View story | View all stories | About Social RSS | Join Social RSS

Using Oracle's Block Browser and Editor tool
In a prior article on Oracle's Block Browser and Editor tool (BBED), the installation of the tool was covered. In this article, we'll look at starting a session using a simple database and see how to view data.

View story | View all stories | About Social RSS | Join Social RSS

Oracle 11g Security Those Pesky Predefined Accounts
How many users do you have in your database? Are they all being used? Come for a ride as we trim down the installed base of Oracle default users.

View story | View all stories | About Social RSS | Join Social RSS

SQL Performance Analyzer
Any activity that may impact a statement's execution plan is a candidate for using SPA to investigate the possible consequences - both good and bad. Steve Callan discusses the workflow and provides a working example.

View story | View all stories | About Social RSS | Join Social RSS

Using Oracle 11g's Active Data Guard and Snapshot Standby Features
This article - the fifth in this ongoing series - illustrates how Oracle 11g's new snapshot standby features leverage a physical standby database for application quality assurance testing, including the new Real Application Testing suite.

View story | View all stories | About Social RSS | Join Social RSS

Oracle Invisible Indexes and Index Usability
Many of the decisions to create an index in production are not always rooted in explain plan analysis or from looking at application code. What often happens is hundreds of indexes cluttering up the databases. Two mechanisms within Oracle could help you clean up these unused ...or performance hoggin...

View story | View all stories | About Social RSS | Join Social RSS

Foreign Key Constraints Revisited
Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.

View story | View all stories | About Social RSS | Join Social RSS

Data Guard: Backup, Recovery, and Active Data Guard
Oracle Data Guard makes it possible to back up a production database using a valid physical standby database as the target for the backups, and those same backups can be used to restore and recover a production database. This article demonstrates how Oracle Database 11...g expands these features to ...

View story | View all stories | About Social RSS | Join Social RSS

Getting Ready for Oracle Flashback Database
Learn how to set up an instance's configuration to make use of Oracle's Flashback Database feature.

View story | View all stories | About Social RSS | Join Social RSS

RMAN Drills
This article and the next cover a couple of RMAN exercises using an older version of Oracle. The exercises or samples cover duplicating a database on the same server, and performing a tablespace point in time recovery (with a built-in error condition that requires some file editing).

View story | View all stories | About Social RSS | Join Social RSS