| Grant Edit Privilege of Package to Another user [message #235644] |
Mon, 07 May 2007 09:48  |
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
|
Member |
|
|
Hi All,
I'm facing one issue with granting edit privilege to another user.
Scenario:
App01 DB user
Under App01 DB user there is one package apppack
I created one more user App02
Granted connect and resource roles to App02.
I granted select and dml permissions of all tables of App01 to App02.
I granted all permissions on functions and procedures.
Granted all on package also.
AS APP01 USER
SQL>GRANT ALL ON APPPACK TO APP02;
Still i'm able to see only the specification of the package from APP02 User.
How to see and edit the package body from APP02 user?
Whether Oracle supports this?
Janet Wilson
|
|
|
|
|
|
| Re: Grant Edit Privilege of Package to Another user [message #235674 is a reply to message #235644] |
Mon, 07 May 2007 11:39  |
 |
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
There are only 6 ways to be able to see the source of a package body:
- you are the owner
- PUBLIC is the owner
- you have the DEBUG privilege on the package or package body
- you have the privilege CREATE ANY PROCEDURE
- you have the privilege DEBUG ANY PROCEDURE
- you have the SELECT privilege on DBA_SOURCE
Regards
Michel
[Updated on: Mon, 07 May 2007 11:40] Report message to a moderator |
|
|
|
| Re: Grant Edit Privilege of Package to Another user [message #235875 is a reply to message #235674] |
Tue, 08 May 2007 04:20 |
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
|
Member |
|
|
Thanks Frank and Michel.
I have one more issue related with the same scenario.
App01 and App02 schemas.
I want to grant create table privilege to App02 only in App01 schema.
I know that it is not possible.
Checked the Oracle Documentation and find that only two create table privilege exists.
1. CREATE TABLE
2. CREATE ANY TABLE
Can you please tell me whether the above statements are coreect or not.
Janet
[Updated on: Tue, 08 May 2007 04:21] Report message to a moderator |
|
|
|
|
|
| Re: Grant Edit Privilege of Package to Another user [message #235905 is a reply to message #235882] |
Tue, 08 May 2007 06:27 |
janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis
|
Member |
|
|
Thanks Michel...
We have one application and one db user for that.
There are many peoples from different departments accessing the DB (only one schema).
So we planned to create two more users and enable the auditing.
Anyway we are going to change our plan.
Thanks again
Janet Wilson
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
