Solved

RO user- what all can they see?

Posted on 2011-02-14
2
184 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL help 5 50
MS SQL order by with "over" statement and row_number() 11 38
Move SQL 2005 Express to Server 2012R2 19 100
TSQL mapping detailed records to group records 9 44
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 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

16 Experts available now in Live!

Get 1:1 Help Now