Re: Permissions when Stored procedure updates table in differnet database

[johnmorris]

Using Sybase 12.5.3 :)
> According to Sybase manual:
>
http://infocenter.sybase.com/help/topic/com.sybase.dc31654_31644_1250/html/sag/X58875.htm
> , under the heading "Understanding ownership roles,
> A view and its underlying objects are usually all in the
> same database, as are a stored procedure and all the
> objects it references; however, this is not required. If
> objects are in different databases, a user wanting to use
> the view or stored procedure must be a valid user or guest
> user in all of the databases containing the objects. This
> prevents users from accessing a database unless the
> Database Owner has authorized it.
> When a user who has been granted execute permission on a
> procedure or view uses it, Adaptive Server does not check
> permissions on any of the underlying objects if:
> - These objects and the view or procedure are owned by the
> same user, and
> - The user accessing the view or procedure is a valid user
> or guest user in each of the databases containing the
> underlying objects.
>
> I have a stored procedure owned by owner A in database 1,
> it will update a table in database 2, owned by owner A.
> User xyz is a valid user in both database A and B and has
> no specific permissions on table in database B. However,
> Sybase will generate error message that stored procedure
> does not have update permissions on table. According to
> Sybase Admin manual, permissions should not even be
> checked. I know I can grant update permission and issue
> would be resolved but this shouldn't be needed according
> to manual. What could be wrong?

[johnmorris]