Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Thursday, April 07, 2016

SAP ASE SQL Script - Who Has Allow HADR Login

Print Friendly and PDF
Whilst working with SAP ASE, I found it useful to have a ready made SQL statement for determining who (which user accounts) has “allow hadr login” privileges.
In my scenario, I needed to be able to check if a specific backup server login account had the “allow hadr login” privilege, to permit backups of a standby SAP SRS replicated database.
Normally you are unable to login as any “normal” user into the standby database without the “allow hadr login” privilege.
use master
select p.uid,,CONVERT(char(20),
from sysprotects p,
     master.dbo.spt_values v,
     sysusers u
where p.action=v.number
  and'Allow Hadr Login'
  and p.uid = u.uid

No comments: