|
If it is any consolation I have also fallen foul of exactly the same situation.
Boss - "Our auditors say that developers should not be able to run the SPs in Production"
Me - "But this isn't Production!"
Boss - "But it is modelled on Production"
Me - "But I can edit them!"
Boss - "Well, it's your job to edit them, you just can't run them"
...
You can imagine the follow up conversation with the Test Manager
Fortunately the DBA saw the light and created a test id with execute rights. So, no personal responsibility as the test id is shared but the auditors are ok with that
|
|
|
|
|
Thhis isn't even an outward facing SQL server - it's solely for the use of the department in which I'm working.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I don't have the benefit of everyone sitting in a room together, or even that of an enlightened DBA. The security is "governed" by the Information Assurance nazis, and the DBA can only give access to the level they dictate. Even if he WAS enlightened, it wouldn't make a difference. I have to go through five layers of bureaucracy to get anything done around here.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
So hell does exist...
If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams You must accept one of two basic premises: Either we are alone in the universe, or we are not alone in the universe. And either way, the implications are staggering.-Wernher von Braun Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
Are we talking about a development environment?
How a developer can done the job if can't run the SPs?
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: How a developer can done the job if can't run the SPs? Speak for yourself. I do all my coding in NotePad and deploy to production during business hours. Only sissies need to test their code.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I would like to see how you handle 1,450,000 lines of SQL code with notepad...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: I would like to see how you handle 1,450,000 lines of SQL code Like a boss.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Yeah, I believe you.
My boss would make a f***-up on at least 1,499,998 of the 1,450,000 lines.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Mark_Wallace wrote: My boss would make a f***-up on at least 1,499,998 of the 1,450,000 lines.
I assume that some lines are f***ed-up so badly that they count twice.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
If there are more than one words in a line, there's scope for more than one f***-ups.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
You seem to have it easy!
Mandatory Dilbert[^]
My blog[ ^]
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
Classic.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
As we do in C#; If it builds, ship it. What could possibly go wrong?
My plan is to live forever ... so far so good
|
|
|
|
|
I have to admit I love reading your posts. My job is freakin' awesome now
-NP
Never underestimate the creativity of the end-user.
|
|
|
|
|
Silver linings, I suppose...
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I have got to agree with Nick, I consider banks a PITA, right up until I read the crap you need to go through.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I believe you are just talking about the political implications of executing an SP, but there is an interesting missing role in SQl Server.
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
Then you can grant the ability that the person can only execute SPs.
It's a good way to secure a DB and still leave it open to SP execution.
See more at:
http://www.sqlmatters.com/Articles/Adding%20a%20db_executor%20role.aspx[^]
If you have all those other rights, you should most certainly have execute.
|
|
|
|
|
It is not healthy to hate your job. Once you hit that point, their is usually nothing that can be done to change your mind. Move on to something else.
|
|
|
|
|
Yup. You should love your job.
Just hate your colleagues.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
And sadly that happens far to often these days. I wish employers would learn that keeping us happy is important to doing business effectively.
My plan is to live forever ... so far so good
|
|
|
|
|
Do they still kill the people that worked on it after the project is done?
See, if you can't be trusted with the things you make.. Who guarantees me you're not going to write weapons of mass-destruction when you're on holiday?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: Who guarantees me you're not going to write weapons of mass-destruction when you're on holiday? On holiday?!?
John manages that much on spare weekends!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Well, Nixon and Kissinger regarded nuclear weapons as unusable, but I didn't know it was because John had programmed them
|
|
|
|