You want to create procedures, functions and packages Which privilege do you need?

You want to create procedures, functions and packages Which privilege do you need?

You want to create procedures, functions and packages Which privilege do you need?

A.
EXECUTE CODE object privilege

B.
CREATE ANY CODE object privilege

C.
CREATE PACKAGE system privilege

D.
CREATE PROCEDURE system privilege

E.
CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges

Explanation:
The privilege CREATE PROCEDURE gives the grantee the right to create procedures, functions, and packages within their schema. This privilege does not give the right to drop or alter the program constructs.
Incorrect Answers
A, B & C are not valid object or system privileges.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Anand Aili

Anand Aili

Are those explanations correct?

mandira

mandira

ya i also want to know that explanation that was given was correct or not ?

Rajiv

Rajiv

D is correct answer