Technical rules are not visible for custom sav role

[Harsha]

Hi Team,

We have a custom sav role which is copy of admin sav role but have removed only few access features like configurations,IDP etc. but am not able to see technical rules or user update rules. 

PS: I have added sav role default to connection can see security points,accounts and things like that except rules.Have I missed anything?

Thanks,

Harsha

[Darshanjain]

Hi @Harsha 

Tech rules are only shown for Role-admin sav role. for custom sav role even if its a role admin copy it wont show. 

Only the Rule owners with access to technical rules will be able to see those user update/technical rules.

Thanks

Darshan

[Harsha]

Hi,

We have too many rules,is there any easier or different way? Can we create user group and assign or something like that? What if we don't wanna make them rule owner?

Thanks,

Harsha

[armaanzahir]

Visibility of rules in any custom sav role not having full admin access would require you to set owners for the same. There is no other way of going about this. 

[Darshanjain]

We dont have any other way, Also for now Rule owners can be only users and not user groups. 

so you need to add all the users

Thanks

Darshan

[Harsha]

Hi @armaanzahir and @Darshanjain ,

Thank you for the quick response. So how can we add for bulk tech rules? we have nearly 300 rules.

Thanks,

Harsha

[Darshanjain]

Hi @Harsha

For one time You can update the table rule_owners from customquery job to add few users as owners for all the rules.

Thanks

Darshan 

[dgandhi]

There is no option for adding bulk rule owners. If you don't want to do it manually then you can use Custom Query Job.

[rushikeshvartak]

Use Custom query to add rule owner 

Insert into rule_owners(rulekey,userkey,rank,updateuser,updatedate) VALUES (9999,8888,1,'admin',utc_timestamp()) limit 1;

9999 is rulekey

888 is userkey / ownerkey

Get Technical rules Rulekey from --> select * from hanarule where type=1

[Harsha]

Hi @rushikeshvartak ,

Above query is failing and logs says as shown below:

Is customquery job working in 23.5 version? If yes, why above is failing?

Thanks,

Harsha