Finding security settings on Geo SCADA objects

[sbeadle]

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.

[BevanWeiss]

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

[sbeadle]

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!