How to maintain database ownership restoring across domains?Maintaining or Re-Gaining access after SQL Server...
Do error bars on probabilities have any meaning?
Ramanujan's radical and how we define an infinite nested radical
Can I legally make a website about boycotting a certain company?
How to scroll to next div using Javascript?
Was Opportunity's last message to Earth "My battery is low and it's getting dark"?
How to write painful torture scenes without being over-the-top
Is it common to refer to someone as "Prof. Dr. [LastName]"?
A semicolon (';') is not needed after a function declaration. C++
Relation between roots and coefficients - manipulation of identities
How to play songs that contain one guitar when we have two or more guitarists?
Why didn't Lorentz conclude that no object can go faster than light?
How to encourage team to refactor
How do I write a maintainable, fast, compile-time bit-mask in C++?
Is it possible to detect 100% of SQLi with a simple regex?
Can a planet be tidally unlocked?
Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?
Why do BLDC motor (1 kW) controllers have so many MOSFETs?
Stream.findFirst different than Optional.of?
Reading source code and extracting json from a url
Identical projects by students at two different colleges: still plagiarism?
How can I portray body horror and still be sensitive to people with disabilities?
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Taking an academic pseudonym?
Is there a way to draw a level tree?
How to maintain database ownership restoring across domains?
Maintaining or Re-Gaining access after SQL Server database restore without SYSADMIN rights?Error on changing ownership of database from Files Page in database properties dialog boxQuickly restoring a backup over top of an existing database - error “database in use”Changing Schema ownership and side effectsManaging Security for a Log Shipped db across two (unconnected) domainsChange the database from restoring state to standby modeSQL Server Login can't see databasesdbcreator role member not able to access database it just restoredUser mapping to a standby databaseCan you DENY access to a certain schema for a user with dbcreator role?
I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, and restoring over the top of the of the database within our domain.
The vendor uses a domain login on our side to access this database. This domain login is also the owner of this local copy. This vendor is trusted enough that we have granted the login the "dbcreator" server role. A combination of database ownership and the dbcreator role allows this domain login to restore a copy of the database over the top of the existing database. The restore completes, but as soon as it's done, the domain login can no longer access the database because the database ownership is lost. (I believe because it had a different owner on the vendor's system). After the restore is complete, I have to re-create the user within the database that matches up to the domain login, and make that user the owner again. The domain login can then access the database again.
Is there any way I can configure this so the vendor is able to perform the restores when they need to without losing the existing ownership? This way I would not have to be involved every time they deploy a new version of the database. I cannot give them sysadmin because there are other databases on the server.
sql-server security restore vendor-support
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, and restoring over the top of the of the database within our domain.
The vendor uses a domain login on our side to access this database. This domain login is also the owner of this local copy. This vendor is trusted enough that we have granted the login the "dbcreator" server role. A combination of database ownership and the dbcreator role allows this domain login to restore a copy of the database over the top of the existing database. The restore completes, but as soon as it's done, the domain login can no longer access the database because the database ownership is lost. (I believe because it had a different owner on the vendor's system). After the restore is complete, I have to re-create the user within the database that matches up to the domain login, and make that user the owner again. The domain login can then access the database again.
Is there any way I can configure this so the vendor is able to perform the restores when they need to without losing the existing ownership? This way I would not have to be involved every time they deploy a new version of the database. I cannot give them sysadmin because there are other databases on the server.
sql-server security restore vendor-support
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, and restoring over the top of the of the database within our domain.
The vendor uses a domain login on our side to access this database. This domain login is also the owner of this local copy. This vendor is trusted enough that we have granted the login the "dbcreator" server role. A combination of database ownership and the dbcreator role allows this domain login to restore a copy of the database over the top of the existing database. The restore completes, but as soon as it's done, the domain login can no longer access the database because the database ownership is lost. (I believe because it had a different owner on the vendor's system). After the restore is complete, I have to re-create the user within the database that matches up to the domain login, and make that user the owner again. The domain login can then access the database again.
Is there any way I can configure this so the vendor is able to perform the restores when they need to without losing the existing ownership? This way I would not have to be involved every time they deploy a new version of the database. I cannot give them sysadmin because there are other databases on the server.
sql-server security restore vendor-support
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, and restoring over the top of the of the database within our domain.
The vendor uses a domain login on our side to access this database. This domain login is also the owner of this local copy. This vendor is trusted enough that we have granted the login the "dbcreator" server role. A combination of database ownership and the dbcreator role allows this domain login to restore a copy of the database over the top of the existing database. The restore completes, but as soon as it's done, the domain login can no longer access the database because the database ownership is lost. (I believe because it had a different owner on the vendor's system). After the restore is complete, I have to re-create the user within the database that matches up to the domain login, and make that user the owner again. The domain login can then access the database again.
Is there any way I can configure this so the vendor is able to perform the restores when they need to without losing the existing ownership? This way I would not have to be involved every time they deploy a new version of the database. I cannot give them sysadmin because there are other databases on the server.
sql-server security restore vendor-support
sql-server security restore vendor-support
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
asked Nov 24 '14 at 19:38
SomeGuySomeGuy
92242137
92242137
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site?
answered Nov 24 '14 at 19:50
armitagearmitage
778410
add a comment |
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
});
}
});
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%2f83513%2fhow-to-maintain-database-ownership-restoring-across-domains%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site?
answered Nov 24 '14 at 19:50
armitagearmitage
778410
add a comment |
Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site?
answered Nov 24 '14 at 19:50
armitagearmitage
778410
add a comment |
Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site?
answered Nov 24 '14 at 19:50
armitagearmitage
778410
Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site?
answered Nov 24 '14 at 19:50
armitagearmitage
778410
answered Nov 24 '14 at 19:50
armitagearmitage
778410
answered Nov 24 '14 at 19:50
armitagearmitage
778410
answered Nov 24 '14 at 19:50
armitagearmitage
778410
778410
add a comment |
add a comment |
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%2f83513%2fhow-to-maintain-database-ownership-restoring-across-domains%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
