Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: no privileg...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 15516 of 17437
Post > Topic >>

Re: no privileges were granted

by tgl@[EMAIL PROTECTED] (Tom Lane) May 13, 2008 at 10:12 AM

Volkan YAZICI <yazicivo@[EMAIL PROTECTED]
> writes:
> test_1_5_0_0=> GRANT EXECUTE ON FUNCTION
emove.emove_outgoingmessages_delete_for_commsrv() TO emove;
> WARNING:  no privileges were granted for
"emove_outgoingmessages_delete_for_commsrv"
> GRANT

> Does anybody have an idea about what might be causing the problem?

What this means is that the user doing the GRANT doesn't actually have
permissions to do it.  (Yeah, the message pretty much sucks, but the
behavior is mandated by SQL spec.)

Most likely, you aren't the owner of the function.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 2 Posts in Topic:
no privileges were granted
yazicivo@[EMAIL PROTECTED  2008-05-13 09:52:27 
Re: no privileges were granted
tgl@[EMAIL PROTECTED] (T  2008-05-13 10:12:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 13:01:08 CST 2008.