I, also, recently left a company where I was 'the guy', and had full
rights to everything. I've moved to a bigger company, and security is
much tighter, and I now have access as you describe.
I am having a lot of difficulty doing tasks that used to take seconds.
Like monitoring performance, seeing where specific files are located.
Looking at logs. Lot's of stuff...
I'm curious about how you will work this out. I am battling every day.
Adam
-----Original Message-----
From: Gord Debiasi
[mailto:mssqldba-ezmlmshield-x8563065.[Email address protected]
Sent: Friday, September 28, 2007 10:53 AM
To: LazyDBA Discussion
Subject: RE: DBA need to have Full rights on Server and SQL server....
Tell them to take the access away from the server, but just share the
C:.....
Bingo same thing.
Crazy company.
-----Original Message-----
From: Perstin Oksana
[mailto:mssqldba-ezmlmshield-x64556217.[Email address protected]
Sent: Friday, September 28, 2007 1:44 PM
To: LazyDBA Discussion
Subject: DBA need to have Full rights on Server and SQL server....
Hi experts,
I want to pass this to get your opinion on this.
As a DBA I have to have full rights on Server and SQL Server. This rule
was with all other companies that I worked with.
It is simply necessary for any troubleshooting purposes ( including
performance counters and any Operating system logs etc..)
Now our management team looking to tight security in our company and
advice us that they will take out DBAs permission from the server and
leave full permissions only on SQL server. To me this will make so many
limitations to complete my job as far as any problems that may come with
SQL server. I think this just not acceptable.
Please let me know your opinions and experience with similar issues if
you ever had that will help me to prove this point of view.
Thank you
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
#####################################################################################
Warning:
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which it is addressed. If you are not the named addressee any review, dissemination, distribution or duplication of this e-mail is strictly prohibited. If you have received this email in error, please let us know by e-mail and delete it from your system. Please note that any personal views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
Thank You.
#####################################################################################
MS Sql Server LazyDBA home page