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.
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
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!
User | Count |
---|---|
188 | |
53 | |
16 | |
16 | |
15 |
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!