Permission on Database
I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb
USE [MyDB]
GO
CREATE USER [Test] FOR LOGIN [TestUser]
GO
GRANT SELECT TO [Test]
GO
DENY DELETE TO [Test]
GO
DENY INSERT TO [Test]
GO
DENY UPDATE TO [Test]
GO
everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update
sql-server permissions users
New contributor
add a comment |
I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb
USE [MyDB]
GO
CREATE USER [Test] FOR LOGIN [TestUser]
GO
GRANT SELECT TO [Test]
GO
DENY DELETE TO [Test]
GO
DENY INSERT TO [Test]
GO
DENY UPDATE TO [Test]
GO
everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update
sql-server permissions users
New contributor
add a comment |
I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb
USE [MyDB]
GO
CREATE USER [Test] FOR LOGIN [TestUser]
GO
GRANT SELECT TO [Test]
GO
DENY DELETE TO [Test]
GO
DENY INSERT TO [Test]
GO
DENY UPDATE TO [Test]
GO
everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update
sql-server permissions users
New contributor
I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb
USE [MyDB]
GO
CREATE USER [Test] FOR LOGIN [TestUser]
GO
GRANT SELECT TO [Test]
GO
DENY DELETE TO [Test]
GO
DENY INSERT TO [Test]
GO
DENY UPDATE TO [Test]
GO
everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update
sql-server permissions users
sql-server permissions users
New contributor
New contributor
edited 1 hour ago
LowlyDBA
7,24752643
7,24752643
New contributor
asked 2 hours ago
user175111user175111
132
132
New contributor
New contributor
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Most probably because you are using the generate scripts method to do so.
I would suggest to use open source DBA tools to view the permission or export.
Aliases : Export-SqlUser
Synopsis
Exports users creation and its permissions to a T-SQL file or host.
Description
Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
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
});
}
});
user175111 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%2f232788%2fpermission-on-database%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
Most probably because you are using the generate scripts method to do so.
I would suggest to use open source DBA tools to view the permission or export.
Aliases : Export-SqlUser
Synopsis
Exports users creation and its permissions to a T-SQL file or host.
Description
Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
add a comment |
Most probably because you are using the generate scripts method to do so.
I would suggest to use open source DBA tools to view the permission or export.
Aliases : Export-SqlUser
Synopsis
Exports users creation and its permissions to a T-SQL file or host.
Description
Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
add a comment |
Most probably because you are using the generate scripts method to do so.
I would suggest to use open source DBA tools to view the permission or export.
Aliases : Export-SqlUser
Synopsis
Exports users creation and its permissions to a T-SQL file or host.
Description
Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.
Most probably because you are using the generate scripts method to do so.
I would suggest to use open source DBA tools to view the permission or export.
Aliases : Export-SqlUser
Synopsis
Exports users creation and its permissions to a T-SQL file or host.
Description
Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.
edited 1 hour ago
LowlyDBA
7,24752643
7,24752643
answered 2 hours ago
KASQLDBAKASQLDBA
5,54261944
5,54261944
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
add a comment |
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
is it probably Export-DbaUser?
– user175111
43 mins ago
is it probably Export-DbaUser?
– user175111
43 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
One more question, can we install this in a prod server?
– user175111
38 mins ago
add a comment |
user175111 is a new contributor. Be nice, and check out our Code of Conduct.
user175111 is a new contributor. Be nice, and check out our Code of Conduct.
user175111 is a new contributor. Be nice, and check out our Code of Conduct.
user175111 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%2f232788%2fpermission-on-database%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