I've got a tool that accesses syslogins to pick up some information.
When I run the tool, I get the error message that sasys that my login
does not have sufficient permissions to read syslogins. If I run under
my admin ID, everything is fine. HOWEVER, the intention is that this
tool will be used by non-DBA staff members so we have a generic id
created to run this tool specifically (non-DBA account).
OK, so I go to Enterprise Manager and open up the master database, go
to syslogins and add my non-DBA id to the permissions list as having
SELECT access, and click on EXECUTE.
BOOM! No sign of my permissions being set.
Am I missing something? If so, what do I need to do to set permissions
against this view?