Microsoft SQL Server forum - Setting permissions on master.dbo.syslogins

Author

Setting permissions on master.dbo.syslogins

byrocat

2005-06-30, 1:24 pm

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?

Erland Sommarskog

2005-06-30, 8:23 pm

byrocat (bdealhoy@sympatico.ca) writes:
> 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.

I would recommend against changing permissions on system objects. I don't
know if this is even supported.

The issue is likely to to be syslogins.password, so if you can change the
tool to list only the columns it needs, you should be fine.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sponsored Links