Oracle Database Administration for Microsoft SQL Server DBAs

Protecting Users from Users

Much of the thought put into backups and recovery is to protect the system from hardware issues or even disasters, but you also need to consider what damage people can do. Developers, users, and DBAs use the database environment for development, testing, running applications, making changes, and just doing their jobs. As a DBA, you probably confirm which environment you are logged in to before making a change. You probably run an extra backup just to give yourself that extra protection in case something goes wrong. But other users may not be so cautious. They may accidentally log in to the wrong environment and drop a table or change a stored procedure. Fortunately, Oracle offers some features to assist in protecting ...