Solved

RO user- what all can they see?

Posted on 2011-02-14
2
190 Views
Last Modified: 2012-06-21
if a user has datareader privileges, what all objects can they see in SSMS - only the tables created by dbo? or all tables (and views)?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 11

Accepted Solution

by:
rajvja earned 500 total points
ID: 34889318
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34890581
rajvja, it says the user can select all user tables. what about view in ssms?
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compare data between two databases 16 112
Sql Query join multiple table and distinct records 7 31
Help Required 2 39
Present Absent from working date rage 11 38
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 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