Wednesday, March 28, 2018

Grant ability to execute sp_who and sp_who2 without granting sysadmin privileges

Subhash Chandra  over at Sql Server Central has written what appears to be a great little procedure for granting someone the ability to run sp_who and sp_who2 without granting them sysadmin privileges.

Grat sp_who2 & who3 without granting sysadmin privileges

I have literally nothing to add :-D  Posting it here mostly so I can easily find it later.  Thanks, Subhash.

DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)

I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...