Re: determine RCAC active on file - best way

Rob,

That is exactly what I am looking for...

when the table has been altered with these statements...
ALTER TABLE
ACTIVATE/DEACTIVATE ROW ACCESS CONTROL
ACTIVATE/DEACTIVATE COLUMN ACCESS CONTROL

C appears in Control when activated and Control is blank when deactivated.

thanks!

Jay


On Thu, Jun 16, 2022 at 9:27 AM Rob Berendt <rob@xxxxxxxxx> wrote:

What's your definition of "activated"?
Do you mean something like this?
Select
System_Table_Name,
System_Table_Schema,
Control
From qsys2.systables
where control <> ''
order by system_table_schema, system_table_name;

Does the value of CONTROL change by
ALTER TABLE
ACTIVATE/DEACTIVATE ROW ACCESS CONTROL
ACTIVATE/DEACTIVATE COLUMN ACCESS CONTROL
?

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay
Vaughn
Sent: Thursday, June 16, 2022 8:38 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: determine RCAC active on file - best way

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


I know you can do the following to determine if any RCAC masking rules
exist on a file...

select sys_cname
from qsys2.syscontrols
where sys_dname = 'LIB'
and sys_tname = 'FILE'
and "ENABLE" = 'Y'

But is there also a simple sql query to determine if RCAC is simply
activated.
RCAC can be activated but no masking rules may exist.

tia

Jay
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com