cs_source - Thursday, December 21, 2017 9:17 AM
Not sure exactly what you mean. Are you talking about granting INSERT rights on the table(s?) involved? Or are you talking about execution rights to the stored procedure involved? And as I have no experience with MDS, I can only guess that MDS_BR_USER is a table involved here in some way, but I don't know how. If you can explain in further detail, it would be helpful.
If it helps any, execution context is going to be what matters. The execution context of the user that runs the stored procedure is what matters where permissions are concerned, until you start using an application that does things, at which point it may not be the user that controls the execution context. Applications often do exactly that.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)