Authid Clause

What authid clause does in executing dynamic SQL?

Questions by deepikazain   answers by deepikazain

Showing Answers 1 - 3 of 3 Answers

dipanjan80

  • Aug 25th, 2010
 

One can use the AUTHID CURRENT_USER clause to make stored procedures and functions execute with the privileges and schema context of the calling user. You can create one instance of the procedure, and many users can call it to access their own data because invoker's rights subprograms are not bound to a particular schema.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions