Posted by Erland Sommarskog on 07/01/05 00:37

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/techinfo/productdoc/2000/books.asp

• Next in forum: Re: MSDASQL to NOTESSQL (odbc)
• Prev in forum: Re: Transaction not commited rollback?
• Thread view: Re: Setting permissions on master.dbo.syslogins

[Reply to this message]