What "read only activity" can exist on databases

Question

What "read only activity" can exist on databases

rbecl

SSC-Addicted

Points: 488
More actions
June 22, 2011 at 5:42 am

#253235

Hi, What "read only activity" can exist on databases?
I am new to SQL and would like to find this out. I regard read-only activity to consist of:
views, stored procedures, sql server agent jobs, log shipping.
Can people please help to clarify if my assumptions are correct? And also can you advise any activities that I have not considered?
Many thanks for your time,
Richard

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

rbecl (6/22/2011)
Hi, What "read only activity" can exist on databases?
I am new to SQL and would like to find this out. I regard read-only activity to consist of:
views, stored procedures, sql server agent jobs, log shipping.
Can people please help to clarify if my assumptions are correct? And also can you advise any activities that I have not considered?
Many thanks for your time,
Richard

Not really sure what you are asking but none of the items you listed are activities. Can you clarify what you are trying to find out?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

rbecl SSC-Addicted Points: 488 More actions · Answer 2

Thank you Sean,

sadly I cannot elaborate further. My manger has to write a report and just told me "Go find out what constitutes "read only activity" on production databases so I can report it to Senior Managment". I'm pretty lost to be honest 🙁

Lowell SSC Guru Points: 323546 More actions · Answer 3

for me "read only activity" means SELECT from views or tables; and more specifically, no INSERT/UPDATE/DELETE/EXECUTE rights to anything else in

the database.

maybe i can get you at least started int eh direction you are looking for.

for me to document that, i'd consider the following:

1. are there any LOGINS that have sysadmin rights that might be used to access the "production" server...they would exceed "read only activity rights".

2. are there any USERS or ROLES in the production database at all? if there are, review each role/user in the SSMS GUI, and see if they are in any roles other than db_datareader, since anything else would again exceed "read only activity rights".

3. drill down on each user and role to see if grants to indeividual objects, like tables/views/etc were granted,a dn if those rights are anything other than "SELECT". if they have rights other than that, they exceed the read-only-ness we are reviewing.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

rbecl SSC-Addicted Points: 488 More actions · Answer 4

Thank you very much Lowell - your help and guidance is much appreciated 🙂