WebMay 13, 2003 · now grant execute on to . by now the can execute the procedure. or u could do as u said the only thing is that the should use the owner prefix while executing the procedure. i.e exec .. Axter. WebA PL/SQL package has two parts: package specification and package body. The package specification is where you declare public items. By default, the scope of package items is the schema of the package. In other words, you can access items declared in a package specification from anywhere in the schema e.g., you can access items in a package ...
granting execute on a Package Body ? - Oracle Forums
WebCode language: SQL (Structured Query Language) (sql) The user jack can create the table.. 3) Using Oracle GRANT to assign privileges which has ANY option example. Some system privileges have the keyword ANY that enables a user to perform the corresponding action on any objects in the database.. For example, SELECT ANY TABLE allows a user to select … WebAug 3, 2012 · grant command to view package body. primefsu Aug 3 2012 — edited Aug 3 2012. I sent a request for the DBA's to grant me rights to the package body but I only … high heel slippers with feathers
How to grant execute access to a package body to another user - Oracle …
WebLet's look at some examples of how to revoke EXECUTE privileges on a function or procedure in Oracle. If you wanted to revoke EXECUTE privileges on a function called Find_Value from a user named anderson, you would run the following REVOKE statement: REVOKE execute ON Find_Value FROM anderson; If you had granted EXECUTE … WebFeb 17, 2011 · Alas, the DBA's here have an aversion to granting "ANY" privs to devs. I'm not sure I understand the drawback of granting access to dictionary views but I'm sure … WebTo grant a privilege on a view, you must have that privilege with the GRANT OPTION on all of the base tables of the view. DEBUG: Access, through a debugger: PL/SQL code in the body of any triggers defined on the view. Information on SQL statements that reference the view directly. DELETE : Remove rows from the view with the DELETE statement. INSERT high heels kids shoes