Make SQL Select Query Read Only
-
Is there a way to set an "Select Only" Mode? I work with SQL Server Management Studio and im afraid of editing some lines while selecting stuff from the database!
-
Answer:
Yes, they are called user permissions. So you need to set the account you have only select rights to the database. So DENY insert ON all TO user DENY update ON all TO user DENY delete ON all TO user
Phil at Stack Overflow Visit the source
Other answers
create a new user with select only permissions. then use that user to connect.
Josh
ALTER DATABASE database-name SET READ_ONLY http://www.blackwasp.co.uk/SQLReadOnly.aspx
Dyno Hongjun Fu
Related Q & A:
- How to convert sql query to Hibernate Criteria query?Best solution by Stack Overflow
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to make only ONE Sql query?Best solution by Stack Overflow
- How to present large dataset from a SQL Server query?Best solution by stackoverflow.com
- How to make a MySql query faster?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.