Tags » Database Administrator

Granting permissions to Users/Roles to view Oracle Triggers

I was asked by a developer to grant them access to view Triggers within the database.  There is no “read only” option to view triggers.  Shown below are the only options to give the user or role. 18 more words


DataGuard Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

This is how I resolved this warning message.

1. Log onto the standby database and stop the redo apply by issuing this command, alter database recover managed standby database cancel; 24 more words


DataGuard error: ORA-16766: Redo Apply is stopped

I encountered this today and I was wondering what recently changed that caused this to happen.  Then I remembered that I added new datafiles to a tablespace that was 97% full on the primary database.   220 more words


A database administrator and a VP-Certification's perspective

A database administrator’s perspective

Paul Button has been a database administrator since he completed his postgraduate studies in computer science 13 years ago. A database administrator is an information technology professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organisation. 170 more words


SQL Server 2016 : New Feature with Import and Export Wizard

Hi Guys, Today when I was just doing some R&D with SQL server 2016 CTP2, got a new feature in “SQL Server Import and Export Wizard”. 118 more words

Database Administrator

SQL Server 2016 Public Preview

Hi Guys, its very surprising morning today, when I opened my mail box in morning, got a subscribed mail from SQL Server Blog’s from technet.com. Its saying Mr. 734 more words

Database Administrator

The Death of SSL?

A vulnerability discovered recently could prove to be the final nail in SSL’s (Secure Socket Layer) coffin. The latest vulnerability to hit SSL, called ‘Factoring attack on RSA-EXPORT Keys’ (or FREAK), is claims to breach as many as 36 percent of all websites trusted by browsers. 387 more words

Database Administrator