AnsweredAssumed Answered

Right Permission to run a update into a Course_User Table

Question asked by as0045500 on Nov 30, 2016
Latest reply on Dec 5, 2016 by as0045500

Hi Guys,


I'am just playing around on my staging enviroment and tried to change a User Enrollment inside a Course (Available or not) using a b2b just to run a simple query, like:



update bblearn_stats.course_users set available_ind = 'N', row_status = 0 where crsmain_pk1 = xxxx and users_pk1 = xxxx


And i'am receiving: ORA-01031: insufficient privileges


This is caused by a missing permission on my manifest?


I know that are another approaches to this result, more efficient and secure, but it's just a curiosity.