Timeline for Deny Delete to An Active Directory Account in Sql Server
Current License: CC BY-SA 4.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 25, 2019 at 3:05 | review | First posts | |||
| Jul 25, 2019 at 7:37 | |||||
| Jul 19, 2019 at 3:05 | review | Close votes | |||
| Jul 19, 2019 at 15:44 | |||||
| Jul 13, 2019 at 19:15 | comment | added | Omer | @JohnEisbrener I answered my question. Thank you very much for reminding it. | |
| Jul 13, 2019 at 19:13 | vote | accept | Omer | ||
| Jul 13, 2019 at 19:13 | answer | added | Omer | timeline score: 1 | |
| Jul 12, 2019 at 11:48 | comment | added | Randi Vertongen | @Omer Great, most of it was you, no need to thank me :). Good luck! | |
| Jul 12, 2019 at 11:46 | comment | added | Omer | @RandiVertongen I have solved my issue with your information. I applied the command to the all databases in the server. Thank you so much. | |
| Jul 11, 2019 at 10:45 | review | Close votes | |||
| Jul 11, 2019 at 22:15 | |||||
| Jul 11, 2019 at 10:22 | comment | added | Randi Vertongen |
DENY DELETE TOonly denies the user in the current database where you execute the statement. Not the entire server/login.
|
|
| Jul 11, 2019 at 10:21 | comment | added | Omer | Sorry. could not understand clearly. Do you want me to write the query? | |
| Jul 11, 2019 at 10:19 | comment | added | George.Palacios | Could you produce a minimal reproducible example please? | |
| Jul 11, 2019 at 10:17 | comment | added | Omer | Yes. I executed this query DENY DELETE TO [usergorup\username] . And command completed succesfully but the users still could be able to delete any record on the database | |
| Jul 11, 2019 at 10:16 | comment | added | George.Palacios | When you say it "didn't work", what exactly have you tried and what happened? | |
| Jul 11, 2019 at 10:13 | comment | added | Omer | There is a SQLDML permission on the User Mapping -> Database role membership for. How can i find that SQLDML permission? Where does it take place? Thank you. | |
| Jul 11, 2019 at 10:11 | history | edited | George.Palacios |
removed irrelevant tags
|
|
| Jul 11, 2019 at 10:11 | comment | added | George.Palacios | What permissions are currently granted? Accounts can't delete data without having permission to do so. | |
| Jul 11, 2019 at 10:04 | history | asked | Omer | CC BY-SA 4.0 |