Home » RDBMS Server » Security » Modify other schema's Package (Oracle 11g)
 Modify other schema's Package [message #641706] |
Thu, 20 August 2015 08:43  |
mvmkandan
Messages: 68
Registered: May 2010
Location: Trivendrum
|
Member |
|
|
Hi Experts,
I want to know that how to modify other schema's Package.
Example:
I have package "XXX" inside AppAdmin schema.
I have another schema "AppUser" and I want to make changes on AppAdmin.XXX package and need to compile.
To resolve the issue, what grant do i need to give to AppUser from AppAdmin.
Thanks,
Veera
[MERGED by LF]
[Updated on: Fri, 21 August 2015 00:58] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Modify other schema's Package [message #641723 is a reply to message #641706] |
Fri, 21 August 2015 00:50  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
You'd rather not do that. Privileges that AppUser needs are way too powerful (ALTER ANY PROCEDURE to modify it, possibly CREATE ANY PROCEDURE and/or DROP ANY PROCEDURE). Granting those privileges, AppUser would be able to modify any procedure/package in that database, not only the ones owned by AppAdmin.
If AppUser should modify AppAdmin's objects, a less dangerous option is to let AppUser know AppAdmin's password so that he'd be able to connect to AppAdmin's schema and do those changes.
However, why would AppUser modify AppAdmin's objects? That doesn't sound well.
P.S. The OP created two topics for the same problem; I didn't realize that it was already answered until I saw the duplicate.
[Updated on: Fri, 21 August 2015 00:59] Report message to a moderator |
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 03:38:56 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
