I've used execute() without specifying full table names (owner.table) and it seems to work fine. :) I thought specifying the schema wasn't needed in execute(), just within a database procedure. Perhaps I am missing something.
Ciao, JLS
Jean-Michel OLTRA wrote:
bonjour,
Le jeudi 20 mai 2004, John L. Singleton a �crit...
Try to use an execute statement. Like:
execute('GRANT ALL ON FOO TO BAR');
moreover, tables names must be complete: owner.tablename I think that parameters are not allowed to define a table name, unless you use dynamic sql
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
