Although Oracle is our main database vendor for our bread butter application, there tends to be several supporting applications that utilize everything from MYSQL to MS SQL Server and often times without consulting with the DBA team.
Today we needed to grant access to one of the application MS SQL Server that we were unaware existed. The individual has since left the company. We needed to gain access to the SA account and this is the way we did it without having downtime.
Thank you Mark Sussinovich and Aaron Bertrand for sharing.
It worked without issue for us. Wanted to ensure that I had this marked so that I remember the information as I’m sure it will happen again.
My Oracle Rants 
Leave a comment