there is a create function privilege, right??

My practice exam review said there wasn't one, just a create procedure privilege, but I think this is wrong?!?!

which is correct?

I am using Self Test Software - Program Units exam. Has anyone used this? I feel that I am seeing quite a few errors in some questions, especially in explanations. (one explanation blatently described a variable declared in a package body as being public since it was declared in the package specification, when obviously I can see that it was declared in the package body!!

Report this post to a moderator

As far as I'm aware there is no create function privilege. There is a create any procedure and create procedure but no function.

I've been using self test software for my dba track exams and they have been very good in my opinion. A few typos here and there but generaly spot on as far as learning goes.

I Haven't used the Dev track STS though so I can't really vouch for how good they are

Report this post to a moderator

I'm beginning to think I am just getting mixed up with the explanations. I was reading another tutorial which stated, you must have the create function privilege, so I started thinking that there must be a GRANT CREATE FUNCTION privilege, when really it's just GRANT CREATE PROCEDURE (which I confirmed with my book). But I just read it too literally. :P

Report this post to a moderator