Can a user with readonly access change SQL server settings Announcing the arrival of Valued...
How to convince students of the implication truth values?
Most bit efficient text communication method?
Significance of Cersei's obsession with elephants?
Do I really need to have a message in a novel to appeal to readers?
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
Is safe to use va_start macro with this as parameter?
Why wasn't DOSKEY integrated with COMMAND.COM?
What is the meaning of the new sigil in Game of Thrones Season 8 intro?
Why are there no cargo aircraft with "flying wing" design?
Can a party unilaterally change candidates in preparation for a General election?
How to tell that you are a giant?
If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
Fantasy story; one type of magic grows in power with use, but the more powerful they are, they more they are drawn to travel to their source
Dating a Former Employee
How can I use the Python library networkx from Mathematica?
Circuit to "zoom in" on mV fluctuations of a DC signal?
An adverb for when you're not exaggerating
Is grep documentation wrong?
If my PI received research grants from a company to be able to pay my postdoc salary, did I have a potential conflict interest too?
For a new assistant professor in CS, how to build/manage a publication pipeline
What is homebrew?
How to compare two different files line by line in unix?
Should I use a zero-interest credit card for a large one-time purchase?
Can a user with readonly access change SQL server settings
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)SQL Application Role access-controlHow do these snapshot isolation level configurations interact on a SQL Server 2005 instance?Disabling SET Statements / Forcing SET Options in SQL Server 2008R2/2012Disabling SET Statements / Forcing SET Options in SQL Server 2008R2/2012Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locksTime out errors - MS access front end with SQL backendRebuilding an entire Microsoft SQL Server DatabaseOccasional Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure errorSET ARITHABORT, .NET, and explanations inconsistency?Exposing SQL Server database to internet
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings.
In their query I can see this at the beginning:
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
I'm worried because we have been having SQL database deadlock issues and performance issue, and Microsoft say SET ARITHABORT OFF should be SET ARITHABORT ON
Thanks.
sql-server configuration users
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings.
In their query I can see this at the beginning:
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
I'm worried because we have been having SQL database deadlock issues and performance issue, and Microsoft say SET ARITHABORT OFF should be SET ARITHABORT ON
Thanks.
sql-server configuration users
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings.
In their query I can see this at the beginning:
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
I'm worried because we have been having SQL database deadlock issues and performance issue, and Microsoft say SET ARITHABORT OFF should be SET ARITHABORT ON
Thanks.
sql-server configuration users
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings.
In their query I can see this at the beginning:
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
I'm worried because we have been having SQL database deadlock issues and performance issue, and Microsoft say SET ARITHABORT OFF should be SET ARITHABORT ON
Thanks.
sql-server configuration users
sql-server configuration users
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
chris cchris c
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
chris cchris c
1
asked 2 mins ago
chris cchris c
1
1
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
chris c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
chris c is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f235112%2fcan-a-user-with-readonly-access-change-sql-server-settings%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
chris c is a new contributor. Be nice, and check out our Code of Conduct.
chris c is a new contributor. Be nice, and check out our Code of Conduct.
chris c is a new contributor. Be nice, and check out our Code of Conduct.
chris c is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f235112%2fcan-a-user-with-readonly-access-change-sql-server-settings%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
