• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

the setting control of the tempDB data file and log file size

Dear all,

as we have vendor to support our MS SQL 2008 R2 and sometime they do something funny that, for example, increase the initial size of hte tempdB log to 2/3 of the disk that holds the tempdb log.

But when the log growth, we can't shrink it to the level smaller than that size.

we will then recieve that the tempeDB log full message and the application stop to work too.

anyway to restrict thyis kind of person, who also has the dba related login to the MS SQL, to change the tempdb data file and log size?
0
marrowyung
Asked:
marrowyung
  • 3
2 Solutions
 
Kent DyerIT Security Analyst SeniorCommented:
Be sure sysadmin and dbo are removed from the user's profile/groupsed that attach to the tempdb..
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
but it seems then they can't admin that and do anything troubleshooting from the MS SQL ?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
they can't even run the:

dbcc opentran(tempdb)
go

Open in new window


and the kill <session id> command ?
0
 
Anthony PerkinsCommented:
If they have to belong to the sysadmin role, then quite frankly you are out of luck.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
aha. I double version one of account's access right, which connect from oralce gateway. only has the public role connect to any DB.

so this is not the one, the other one will have sa access as they are the vendor, or we have to support 24x7..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now