Subject | Owner |
---|---|
Author | James |
Post date | 2004-04-21T02:39:26Z |
Good day.
Recently Iam trying to gain additional knowledge about granting
previliges. I have just recently know that in order for a procedures to
work it also needs to have the necessary previliges it needs to execute.
While Iam not aware of this before Iam not granting any previliges to SP
I created. Then I discover that if the table and the SP has the same
owner it doesn't need previliges anymore. My question is where can I see
the information on regards who is the owner of the objects in my DB? Iam
using IBExpert.
Thanks.
regards,
james
Recently Iam trying to gain additional knowledge about granting
previliges. I have just recently know that in order for a procedures to
work it also needs to have the necessary previliges it needs to execute.
While Iam not aware of this before Iam not granting any previliges to SP
I created. Then I discover that if the table and the SP has the same
owner it doesn't need previliges anymore. My question is where can I see
the information on regards who is the owner of the objects in my DB? Iam
using IBExpert.
Thanks.
regards,
james