ProfessionalAmateur
Reputation
293
Next privilege 300 Rep.
Create new tags
Badges
1 4 16
Impact
~34k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
12h
asked When executing a command via xp_cmdshell what user issues the command to the system?
Apr
25
revised DENY access to EXEC for a role
edited tags
Apr
2
awarded  Notable Question
Mar
4
awarded  Popular Question
Sep
28
awarded  Popular Question
May
26
awarded  Famous Question
May
14
comment DENY access to EXEC for a role
I do have a role created, and that is where all my permissions are set. With your first example, would I need to DENY the EXECUTE on every object name (ex: every sp_command) or can I do a global DENY for all procedures?
May
14
asked DENY access to EXEC for a role
Apr
25
awarded  Popular Question
Apr
18
awarded  Popular Question
Apr
14
awarded  Popular Question
Nov
19
awarded  Notable Question
Sep
23
comment SMSS will start for one user, but not another?
Deleting the users profile did the trick. Thank you for the assistance!
Sep
23
accepted SMSS will start for one user, but not another?
Sep
23
comment SMSS will start for one user, but not another?
Thanks Aaron, I've run the repair and still same results. (Works for me and not him). Im going to delete his user profile and see what happens. I'll update in a few with results.
Sep
23
asked SMSS will start for one user, but not another?
Jul
2
awarded  Curious
May
6
comment Help understanding SQL Server Developer License when users test via webserver
Thanks. Its 100% testing only. Appreciate the input.
May
6
comment Help understanding SQL Server Developer License when users test via webserver
@MaxVernon - Thanks. Do you know how this is handled with employee turnover? If we buy 60 licenses for the dev box, but have turnover throughout the year (which is very common), but all the access is done via-multiplexing I'm not sure how to track active licenses for the year?
May
6
asked Help understanding SQL Server Developer License when users test via webserver