All, we've run into a strange problem when creating a stored procedure that accesses views and tables like this:
- User A has created a set of tables and grants SELECT access to them to user B. - User B creates a view that references those tables that user A owns. - User B then tries to create a stored procedure that returns a cursor by selecting from the view above. I say "tries" because the CREATE DBPROC statement fails with a "General error;-918 POS(177) Stack overflow". - If instead user A creates the view and then the procedure everything works fine. Is this a bug, or is it just too complex an operation to calculate the requisite access rights if the owner of the procedure is not also the owner of any objects that are used in the procedure? Any insight appreciated! Johan Hellgren _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
