December 21, 2017 at 9:17 am
Hello all,
I'm not sure if i'm posting this in the correct area however it is an MDS related question.
I have a business rule that essentially executes a stored procedure and that works great however the stored procedure does insert records into a table in another database and i'm not sure how to provide the user who is exploring (MDS_BR_USER) access to preform that function to the database and the specific tables?
Any insight or direction? Thank you!
December 26, 2017 at 6:55 am
cs_source - Thursday, December 21, 2017 9:17 AMHello all,
I'm not sure if i'm posting this in the correct area however it is an MDS related question.I have a business rule that essentially executes a stored procedure and that works great however the stored procedure does insert records into a table in another database and i'm not sure how to provide the user who is exploring (MDS_BR_USER) access to preform that function to the database and the specific tables?
Any insight or direction? Thank you!
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)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply