ProfessionalAmateur
Reputation
263
Next privilege 300 Rep.
Create new tags
Badges
1 3 14
Impact
~24k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
May
26
awarded  Famous Question
May
14
comment How to DENY access to EXEC for a role
Thank you, it makes sense. I will give it a whirl and try.
May
14
comment How to DENY access to EXEC for a role
But the role only exists within the database itself, not withing master. When I try that it cannot find the role in MASTER. DO I need to add the role to both the MASTER db and the db with the data they are accessing?
May
14
comment How to 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
comment How to DENY access to EXEC for a role
@kin - I will try that and update with the results.
May
14
comment How to DENY access to EXEC for a role
I really only want them to be able to select from the 4-5 tables I have granted access to. I do not want them to be able to do anything else at all.
May
14
asked How to 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
May
2
comment Compressions vs shrinking a database
It sounds like compression will increase your query performance (given that you have enough CPU to go around) and that shrinking will not affect query performance at all?