Re: determine RCAC active on file - best way

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

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