| Subject | Re: [firebird-support] Re: > Hi, > > I have a stored procedure, which is inserting/deleting some records fo |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2010-05-24T15:15:41Z |
On 5/24/2010 9:58 AM, ardatun wrote:
You have issued a GRANT to user SP_TEST instead of PROCEDURE SP_TEST.
Change from "GRANT SELECT ON MYTABLE TO SP_TEST;"
to "GRANT SELECT ON MYTABLE TO PROCEDURE SP_TEST;"
--
Doug C.
-----
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?
> Thank you again but it didn't work??You still are not paying adequate attention to the GRANT statement syntax.
>
You have issued a GRANT to user SP_TEST instead of PROCEDURE SP_TEST.
Change from "GRANT SELECT ON MYTABLE TO SP_TEST;"
to "GRANT SELECT ON MYTABLE TO PROCEDURE SP_TEST;"
--
Doug C.
-----
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?