706: Execute privilege denied
Why does the following script fail to grant execute to public? I'm curious
because as the dba (person who created the database) I am able to drop
the object z.y etc. Thanks.
drop database x;
create database x with log mode ansi;
create procedure z.y ()
end procedure;
grant connect to public;
grant execute on z.y to public;
706: Execute privilege denied on procedure (Z.y).
--
Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707,Stn.T
Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr.
Cognos Incorporated Email: nigelc@cognos.com Ottawa ON K1G 4K9
http://www.cognos.com CANADA
My comments are my personal opinion and are not the opinion of my employer or
anyone else. I claim copyright in all my statements and give no one the right
to copy them (even if they are quoted elsewhere) in any medium except on
netnews or email. In particular, no one can reproduce or reprint my comments
in print or any visual medium without getting my explicit permission.