41578members
184640posts

Finding security settings on Geo SCADA objects

Highlighted
Sisko

Finding security settings on Geo SCADA objects

Hi All,

 

someone recently asked me to help diagnose a security issue - it seemed that the permissions on an object were not as expected. Sure enough, this was true, but in a complex tree of objects it takes some clicking on each group to find out where the permissions from the root have been changed.

 

There's a good way to find these though. Open a query and enter the following SQL:

 

SELECT ID, FullName, ACLInherited FROM CDBOBJECT WHERE ACLInherited = False ORDER BY FullName

 

This will show all objects with non-defaulting security!

 

Steve

p.s. you can do the same with the colour palette using the column ColourPaletteInherited.

2 REPLIES 2
Highlighted
Commander

Re: Finding security settings on Geo SCADA objects

Does anyone ever change the colour palette at different locations of the database?  If so... I hate them 😛

It is so incredibly difficult to explain to operators what all of the colours mean, if they meant different things in different parts of the database... wow... head explosion.

 

On the ACLs..

Previous discussion around a similar query.. which shows a little more info


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Highlighted
Sisko

Re: Finding security settings on Geo SCADA objects

The trials of product management. Remove a feature no-one uses (or even ought to use) and 3 people complain that it's the most important thing ever!