Ttyjukl

Can I cause damage to electrical appliances by unplugging them when they are turned on?

What does "Scientists rise up against statistical significance" mean? (Comment in Nature)

What is the difference between lands and mana?

Circuit Analysis: Obtaining Close Loop OP - AMP Transfer function

Is there a RAID 0 Equivalent for RAM?

C++ copy constructor called at return

Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?

Doesn't the system of the Supreme Court oppose justice?

PTIJ: Why is Haman obsessed with Bose?

When were female captains banned from Starfleet?

Why the "ls" command is showing the permissions of files in a FAT32 partition?

Is this toilet slogan correct usage of the English language?

Shouldn’t conservatives embrace universal basic income?

Which was the first story featuring espers?

What features enable the Su-25 Frogfoot to operate with such a wide variety of fuels?

US tourist/student visa

Taxes on Dividends in a Roth IRA

Is there any evidence that Cleopatra and Caesarion considered fleeing to India to escape the Romans?

How does electrical safety system work on ISS?

How to get directions in deep space?

Pre-mixing cryogenic fuels and using only one fuel tank

Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?

Multiplicative persistence

How could a planet have erratic days?

Permission on Database

Create users in SQL Server 2012Role-Schema Permission issue (Management studio)Why scalar valued functions need execute permission rather than select?Grant access to all objects (with a few exceptions) to a roleHow do you GRANT SELECT on hidden resource database mssqlsystemresource?Cross database reference select access with disabled login for DB userDeny dbo schema permissionHow to create mysql user with CREATE USER grant but without access to new databases?Why securityAdmin does not have enough permission?PostgreSQL - Grant privileges as superuser

2

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

share|improve this question

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 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 | 

2

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

share|improve this question

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 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 | 

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

share|improve this question

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

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

share|improve this question

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 1 hour ago

LowlyDBA

7,24752643

edited 1 hour ago

LowlyDBA

7,24752643

asked 2 hours ago

user175111user175111

182

New contributor

user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 hours ago

user175111user175111

182

1 Answer
1

active

oldest

votes

4

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.

share|improve this answer

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  is it probably Export-DbaUser?
  
  – user175111
  52 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  One more question, can we install this in a prod server?
  
  – user175111
  46 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes it's widely used and recommended by community. As always said, test in lower environments and go to prod from there. Visit dbatools security page to get more clarification on this
  
  – KASQLDBA
  3 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.

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

4

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.

share|improve this answer

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  is it probably Export-DbaUser?
  
  – user175111
  52 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  One more question, can we install this in a prod server?
  
  – user175111
  46 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes it's widely used and recommended by community. As always said, test in lower environments and go to prod from there. Visit dbatools security page to get more clarification on this
  
  – KASQLDBA
  3 mins ago
  

  
  
  
  

add a comment | 

4

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.

share|improve this answer

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  is it probably Export-DbaUser?
  
  – user175111
  52 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  One more question, can we install this in a prod server?
  
  – user175111
  46 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes it's widely used and recommended by community. As always said, test in lower environments and go to prod from there. Visit dbatools security page to get more clarification on this
  
  – KASQLDBA
  3 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.

share|improve this answer

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

share|improve this answer

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

edited 1 hour ago

LowlyDBA

7,24752643

edited 1 hour ago

LowlyDBA

7,24752643

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944

answered 2 hours ago

KASQLDBAKASQLDBA

5,54261944