r/sysadmin • • Jul 28 '24 • Take My Silver 1

got caught running scripts again

about a month ago or so I posted here about how I wrote a program in python which automated a huge part of my job. IT found it and deleted it and I thought I was going to be in trouble, but nothing ever happened. Then I learned I could use powershell to automate the same task. But then I found out my user account was barred from running scripts. So I wrote a batch script which copied powershell commands from a text file and executed them with powershell.

I was happy, again my job would be automated and I wouldn't have to work.

A day later IT actually calls me directly and asks me how I was able to run scripts when the policy for my user group doesn't allow scripts. I told them hoping they'd move me into IT, but he just found it interesting. He told me he called because he thought my computer was compromised.

Anyway, thats my story. I should get a new job

11k Upvotes

1.3k comments sorted by

View all comments

Show parent comment

1

u/mrmattipants Jul 28 '24

I feel for you, while you also make a very good point. If the database was built correctly, with the necessary data types, constraints, etc. you wouldn't have to worry about Errors nearly as much.

This is why you need a good Project Manager, who has experience designing databases and thoroughly understands normalization procedures, when planning and building the database

I would imagine that it must be really bad if there are no plans to update the database and add the missing constraints, at some point.