Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Posts
    34

    Unanswered: Need importance of fenced user

    Hello,

    While creating the instance we need fenced userid. why there is need of fenced userid while creating it. Can we create instance with instance owner id.

    I know fenced userid is used to create user defined functions and Procedures.

    What are the other benefits of using fenced user?

    Thanks in advance

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    Couple of things on this. Personally I always go with Fenced, reason being if there is an issue with a stored procedure it is much safer for the database overall. I have heard there is a performance impact to doing this but I have not personally noticed a difference. The following article goes into detail: http://www.ibm.com/developerworks/da...le/dm-0510law/
    With the fenced user, I have seen systems that use the instance id and others use a different userid. The only advantage I know of with using a separate userid is security. If it runs under the procedure runs under the instance id it of course has the related security.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •