--- In firebird-support@yahoogroups.com, James <james_027@t...> wrote:

> 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.

James, take a look at Planning Security chapter in IB6 Data
Definition Guide. You can download free IB6 Open Source docs using
links at www.ibphoenix.com .

> 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?

Take a look at structure of RDB$RELATIONS, RDB$PROCEDURES and
RDB$ROLES tables. System tables description you can find in Language
Reference.

Best regards,
Alexander