Impact of data modification in s_nq_job table

Question

Hello Experts,

I want to know that what will happen if someone modify the table.column  "s_nq_job.user_id" related to agents.

Table Name:- s_nq_job

Column data modified:- user_id (example if user1 name is present  as data and someone run the script and update the information of user1 to Test1).

Will the agent will have any impact and it will throw any error while we run ?

Kindly guide.

Thanks & Regards,

Abhi

[Deleted User] · Answer

Hmmm that "GDPR requirement" is questionable to say the least. That simply isn't the point of or the way GDPR works.

Once more: Those are system tables and no one should ever access them via SQL to begin with!

Joel Acha · Answer

I would consider using an Oracle Database feature called Oracle Data Redaction that is part of Oracle Advanced Security that is licensed separately.

https://docs.oracle.com/cd/E11882_01/network.112/e40393/redaction.htm#ASOAG594

User_B7ZTH · Answer

Hello All,

Thank you for your reply and sorry for my late reply.

Requirement is to mask the data as the GDPR regulation.

We have user-id which are present over there who has scheduled the report in agent and we have to mask the user-id.

I know that if we change the user_id to some masked id then it will give the error as authentication failed user_id/password invalid.

Kindly let me know if there is a way that we can mask the user_id information present under s_nq_job.

Thanks & Regards,

Abhi