Solved

User cannot view all records in sys.server_principals

Posted on 2013-11-11
1
509 Views
Last Modified: 2013-11-12
I granted the user db_reader role for mater database and also view definitions but the user can only see 11 records out 1700. Which permissions should I grant so that he can have read only access to all the records in sys.server_principals and sys.sql_logins?
0
Comment
Question by:YZlat
1 Comment
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 250 total points
ID: 39640275
USE master

GRANT VIEW ANY DEFINITION TO [login_name]
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now