Reputation
1,835
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
12 36 58
Impact
~579k people reached

  • 0 posts edited
  • 0 helpful flags
  • 213 votes cast
Mar
31
comment How to deny drop permission for a table?
I'm talking about db_owner role, not dbo user, those are different things.
Mar
30
comment How to deny drop permission for a table?
If this user has a db_owner role, is does not seem to affect the users ability to drop this table.
Mar
30
asked How to deny drop permission for a table?
Mar
26
accepted What factors prevent and delay TRUNCATE command?
Mar
25
asked What factors prevent and delay TRUNCATE command?
Mar
1
accepted Is configuring Database mail considered as a security threat?
Feb
29
comment Is configuring Database mail considered as a security threat?
There stands in this document that: Because some system procedures interact with the operating system or execute code outside of the normal SQL Server permissions, they can constitute a security risk. System stored procedures such as xp_cmdshell or sp_send_dbmail are off by default and should remain disabled unless there is a reason to use them.
Feb
29
asked Is configuring Database mail considered as a security threat?
Feb
23
awarded  Nice Question
Feb
22
accepted What is the difference between a connection and a session?
Feb
22
asked What is the difference between a connection and a session?
Feb
18
accepted Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
Feb
17
asked Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
Feb
16
awarded  Peer Pressure
Feb
11
accepted Differences between CMS and MSX/TSX?
Feb
11
accepted Is there a reason to update statistics manually?
Feb
10
asked Differences between CMS and MSX/TSX?
Feb
10
asked Is there a reason to update statistics manually?
Feb
4
accepted Is it possible to assign sql logins into a group?
Feb
3
asked Is it possible to assign sql logins into a group?