[Alex Menard]

Thanks Mike, I’ll have a look to confirm the status.

[Alex Menard]

A status can be configured to “Block Activity”. When applied to a task, this status prevents labor from being added and blocks modifications to the BOM.

[Alex Menard]

Thanks, a few grants with options was able to make it work.

Alex

[Alex Menard]

Thanks, the solution works. This is exactly what was needed.

[Alex Menard]

I tried the grant statement in crystal and I get an error:

ORA-01720: grant option does not exist for ‘QCTL.WO_TASK_LABOR’
01720. 00000 – “grant option does not exist for ‘%s.%s'”
*Cause: A grant was being performed on a view or a view was being replaced
and the grant option was not present for an underlying object.

*Action: Obtain the grant option on all underlying objects of the view or
revoke existing grants on the view.

The crystal view we are trying to grant access queries multiple tables in qctl. It looks like we will have to grant access on qctl tables to crystal with the grant option before granting select on crystal.view on qctl.

Alex

[Alex Menard]

Thanks for the feedback.

Alex