dogbot
Full Member
Posts: 8,738
|
Post by dogbot on Aug 24, 2023 10:47:59 GMT
Does your "net nanny" fail closed, then?
I'm just imagining what might occur if we did that with zScaler. We're still not allowed to turn off the functionality which allows certain users to switch it off at whim, 3 months after go live.
"But what if... 😱 "
There's gonna be actual bloodshed when the zero trust setup goes live next year.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 24, 2023 11:03:03 GMT
All web traffic goes through a proxy and assessed with a risk level based on various categorisations. If it hasnt seen something before or has a high risk level, the user gets a 'blocked. please annoy security to unblock it' message. We then add it to a timed whitelist for a few months if there is a business case for it. If that doesnt get the site working, its a network issue and I dont care about it.
Its an old proxy and we are moving to skyhigh soon so whatever but its still annoying.
|
|
askew
Full Member
Posts: 6,831
|
Post by askew on Aug 24, 2023 13:56:34 GMT
|
|
zephro
Junior Member
Posts: 3,011
|
Post by zephro on Aug 24, 2023 18:08:01 GMT
Our IT just gave Devs admin permissions on our laptops in my previous job. Zscaler being one of the reasons why, it basically stopped anything from working. They were then shocked to find out most Devs used their admin permissions to just remove the fucking thing.
Then again they were also surprised when we all changed our outlook endpoints with admin privileges so that it didn't need to be on the VPN.
ATOS are genuinely clowns.
|
|
|
Post by dfunked on Aug 24, 2023 19:20:42 GMT
"Devs with admin permissions" just made me break out in a cold sweat...
|
|
zephro
Junior Member
Posts: 3,011
|
Post by zephro on Aug 24, 2023 22:02:10 GMT
"Devs with admin permissions" just made me break out in a cold sweat... Always been my life. The IT people were always so behind whatever we were up to they gave up. The transition to the cloud, like 10 years ago, involved me filling out forms about where the server physically was, it's static IP etc. When it all meant nothing. They could understand whatever bullshit happened on Windows though. Except when they couldn't and needed my help Outsourced nonsense mostly. But they are fucking Microsoft idiots.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 24, 2023 22:52:54 GMT
Conversely, at our place they are hurriedly reeling the dev machines back in after only recently letting them off the lead because the galaxy brains operating them keep installing malware from the first Google hit they find for something like a PDF converter.
|
|
|
Post by 😎 on Aug 25, 2023 0:04:07 GMT
Our devs are mostly alright but there was one guy who had a “I am the most important person here and I deserve unfettered access” attitude. Guy, you’re in a hospital and your job is maintaining a couple of forms on an internal CMS.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 25, 2023 8:08:52 GMT
Pretty much all of the ones Ive come across have been the living embodiment of Dunning-Kruger. But then I only meet them when they do something dumb. Which is constantly.
|
|
dogbot
Full Member
Posts: 8,738
|
Post by dogbot on Aug 25, 2023 8:32:36 GMT
I generally believe that most people will behave like adults when they're treated like adults. And mostly, that's borne out. Obviously, there's always special cases.
That said, most of the dev here is done on AWS playgrounds that have no interaction with production stuff and they can do what they like with, within a set of controls they agreed to. Some of them get Macs as laptops, but they're still MDM controlled and locked down, beyond the software build profile and tools they request. They do usually get the tools they need to work, though.
No one has access to local admin at all times except the helpdesk. There's no reason why anyone would. Most people with Azure admin access can PIM to local admin for specific tasks, but it's all audited.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 25, 2023 8:36:28 GMT
I generally believe that most people will behave like adults when they're treated like adults. Well, this is the thing. 'Most' is the problem. If you have 100 devs and 99 are well behaved and one is an arrogant moron, it only takes the last guy to ransomware your entire organisation (or, in our case, install a RAT and allow all kinds of azure configs to be exfilled). 'As strong as your weakest link' and all that.
|
|
dogbot
Full Member
Posts: 8,738
|
Post by dogbot on Aug 25, 2023 8:44:12 GMT
I generally believe that most people will behave like adults when they're treated like adults. Well, this is the thing. 'Most' is the problem. If you have 100 devs and 99 are well behaved and one is an arrogant moron, it only takes the last guy to ransomware your entire organisation (or, in our case, install a RAT and allow all kinds of azure configs to be exfilled). 'As strong as your weakest link' and all that. Don't get me wrong - I still don't grant people full access without a proper business case and the correct approval and so on.
I meant more working with them to explain what they're expected to adhere to.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 25, 2023 9:04:27 GMT
Its a business run decision at our place. We just have to live with it and complain about it bitterly. We dont grant people access to shit (the SOC that is).
|
|
X201
Full Member
Posts: 5,152
Member is Online
|
Post by X201 on Aug 25, 2023 9:38:35 GMT
...he's lost his shit, got his hair right off. It started with "It's one simple task, I don't know why you can't just do it quickly" and ended up with him calling me a "lazy, feckless wanker". He needs the Serious Tetchy Business Thread
|
|
|
Post by Bill in the rain on Aug 25, 2023 9:43:15 GMT
"Devs with admin permissions" just made me break out in a cold sweat... *waves*
|
|
zephro
Junior Member
Posts: 3,011
|
Post by zephro on Aug 25, 2023 17:00:00 GMT
Our Ops were great. They handled the full infosec certification, got the pen tests done, worked with us to make sure everything on AWS was proper. They were in house though.
The IT as in work laptops was outsourced to ATOS as well as some on prem windows servers. They were completely fucking useless. Hence engineering just getting admin powers. They licensed us MacBooks (or some Ubuntu ones )but clearly barely knew how they worked. Their processes were entirely unable to deal with command line tools being approved installs, so say git ended up needing elevated privileges just to run, or when they rolled out zScaler managing to block GitHub access for 500 Devs. Or blocking our own infosec approved SSH tunnels. Or the whole attempt to get http/2 working had to be done off the VPN as it fucked with headers so aggressively.
There was also the episode with them hosting a critical 2nd party system on prem, dunno why, possibly as I said I wanted nothing to do with Windows. Wasn't working still a week before go live so I had to step in, took me a couple minutes to find the logs, spot a privilege error and suggest they create a machine user with correct privileges. They didn't know what that meant so just ran it as admin. Morons.
|
|
dogbot
Full Member
Posts: 8,738
|
Post by dogbot on Aug 29, 2023 15:09:16 GMT
I've just been asked by a very senior person if I can teach their apprentice about Wireshark before their exam on Friday. They work in Risk & Compliance and have never done anything technical in their life. Might need to have started a bit sooner, sweetheart.
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 29, 2023 15:20:35 GMT
This sounds like a job for an Indian tech youtuber
|
|
dogbot
Full Member
Posts: 8,738
|
Post by dogbot on Aug 29, 2023 15:26:04 GMT
Yeah.
I have to be honest, I'm not sure if I fancy his chances of learning enough about TCP/IP to use Wireshark to do a traffic investigation by Friday. 😁
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Aug 29, 2023 15:52:15 GMT
Well, this is the thing. Wireshark itself isn’t that hard to use. The trick is knowing what you’re looking at.
I’ve demo’d forensic file extraction from a pcap to our juniors before which would be a phrase that means nothing to someone who works in risk and controls.
|
|
askew
Full Member
Posts: 6,831
|
Post by askew on Aug 29, 2023 16:13:29 GMT
It's all hex to me
|
|
Bongo Heracles
Junior Member
Technically illegal to ride on public land
Posts: 4,663
Member is Online
|
Post by Bongo Heracles on Sept 1, 2023 20:25:44 GMT
DPM will do granular data restores if you’re lucky with timings. And check the cadence of your hyper v checkpoints, you might be lucky there, too.
Dunno if there is anything that can just roll back a VM with no previous config, tho
|
|
Onny
Junior Member
Posts: 1,155
|
Post by Onny on Sept 2, 2023 11:08:20 GMT
What sort of data are you recovering? VHD is a pretty easy format to work with - open source tools like photorec will pull back common file types, for example, if you’re looking for a series of discrete files (like a bunch of documents).
If it’s something a bit more esoteric - or more complex, like a series of deltas to a prod DB - you might have more of a problem.
|
|
Onny
Junior Member
Posts: 1,155
|
Post by Onny on Sept 2, 2023 19:13:08 GMT
Oh documents etc? You might be ok then. Is that 3TB volume at capacity or does it have loads of space? If the disk is even half empty you have a decent chance of recovering them.
It does get more complicated for documents which are updated, but for those which were created during those 5 hours you’ll likely be golden.
Photorec is your friend, but bear in mind that it might mistakenly label docs/xlsx as zips, since that’s what they are under the hood.
|
|
Psiloc
Junior Member
Posts: 1,567
|
Post by Psiloc on Oct 2, 2023 10:53:23 GMT
Any DBAs in here?
I'm currently involved in chasing down a performance issue with the SQL Server backend of one of our products.
I'm far from an expert at this, but one of the recent expensive queries according to the performance dashboard is the CREATE statement for one of our stored procedures. It's been executed over 6,000 times and I'm seeing that number increase.
Is this just how the performance reports refer to stored procedures? Or is something repeatedly running the CREATE statement?
|
|
mrpon
Junior Member
Posts: 3,772
Member is Online
|
Post by mrpon on Oct 2, 2023 15:14:52 GMT
Without knowing what the backend product is doing, it's difficult to ascertain if that is normal behaviour or not. The SP could be locking a number of tables either row based or page based which then has an impact further down the line.
|
|
nazo
Junior Member
Posts: 1,312
|
Post by nazo on Oct 2, 2023 17:01:03 GMT
As in the SP is getting recreated constantly? I wouldn't expect that but it's been a while since I used SQL Server
|
|
Psiloc
Junior Member
Posts: 1,567
|
Post by Psiloc on Oct 3, 2023 11:31:21 GMT
If the report is trying to say that’s how often the SP is being executed then it makes perfect sense. It’s just weird that the query it reports is the CREATE statement, which definitely should not be running repeatedly
Just wanted a second opinion before I make a fool of myself and suggest the software may be erroneously running a CREATE script in a loop
|
|
mrpon
Junior Member
Posts: 3,772
Member is Online
|
Post by mrpon on Oct 3, 2023 13:07:00 GMT
Is the query it reports the CREATE statement to create the SP itself like nazo mentioned? Or a CREATE statement that is built into the SP?
If the former, then yes that's odd and potentially an incorrect loop or poor coding.
If it's the latter, then only you can answer that, which you have.
|
|
Psiloc
Junior Member
Posts: 1,567
|
Post by Psiloc on Oct 3, 2023 13:28:43 GMT
The former - it's reporting the CREATE statement for creating the SP itself. Which would fail every single time because the SP already exists
|
|